5 Replies Latest reply: Oct 2, 2018 11:25 AM by Nagesh Setty RSS

    Qlik Sense - How to get the character value from the record with the minimum date in the set

    Martin Papier

      I am trying to get the character value from the record with the minimum date in the set (the set being ItemNo).

       

      Here is my source data

      ItemNoMyDateMyChar
      101/05/2018N
      101/06/2018Y
      101/07/2018Y
      101/08/2018Y
      201/05/2018Y
      201/06/2018N
      201/07/2018N
      301/07/2018N
      301/08/2018Y

       

       

      and this is what I want as output

      ItemNoMyChar
      1N
      2Y
      3N

       

        Please can somebody point me in the right direction?