6 Replies Latest reply: Sep 26, 2017 1:51 PM by qlik tech RSS

    Retrieving the latest record for dimension values.

    qlik tech

      Hi,

       

      I have data for mobile numbers along with the latest call date/time. I want to capture the mobile number with the latest time.

       

      Eg:

       

      Mob   Call date/time 

      ccc     25/09/2017 10:00:00

      ccc     24/09/2017 10:00:00

      xxx     25/09/2017 10:00:00

      bbbb   25/09/2017 10:00:00


      My report should be

      Mob   Call date/time 

      ccc     25/09/2017 10:00:00

      xxx     25/09/2017 10:00:00

      bbbb   25/09/2017 10:00:00


      I need to exclude ccc and pick up only the laatest record for ccc.