2 Replies Latest reply: Jun 27, 2013 3:01 AM by Tresesco B RSS

    Please help me to form this set expression

    Vishnu Sreekumar

      Hi all,

       

      I have a qlikview internal table that contains information like student_id, gift_id, gift_date, gift_type etc.

      In a straight table, i need to display against each student_id, the latest gift_date, its corresponding gift_id, gift_type etc.

      The latest gift_date of course can be found using max(gift_date). But for its corresponding gift type, what i tried was something like

      =if(gift_date=max(gift_date),gift_id) .. and this seems logically wrong.

       

      Can anyone please help me with this?

       

      Regards,

      Vishnu