1 Reply Latest reply: Sep 25, 2017 10:46 AM by Lee Fraser RSS

    Working With Dates

    Lee Fraser

      Hi All - New QlikSense user here - moving from Excel.

       

      Im trying to create some script in my app which will only show the latest 3 dates for a specific person who has 30 dates recorded against them.

       

      I have tied sumarrize my data in a small table below showing that PersonA has 7 records, but I only want the latest 3 records.

      Columns A & B show all Persons and Dates, COlumns C & D show count of Person A, Columns E & F should show latest 3 dates for Person A.

            

      PersonDate CountPerson ALatest 3 Dates
      PersonA12/01/2013           PersonA71 12/1/16
      PersonB12/03/2014 HELP
      PersonC12/05/2014 HELP
      PersonD12/06/2017
      PersonA12/01/2016
      PersonB12/03/2014
      PersonC12/05/2014
      PersonD12/06/2017

       

       

      I have managed to show the last Date by using Max(Date)

      Any solutions or advice would be welcome.  Unfortunately I cannot load the qvf file due to security issues.

       

      Kind regards

       

      Lee

        • Re: Working With Dates
          Lee Fraser

          To Summarize - I would like a table to show below

           

          Name          Latest Date 1     Latest Date 2     Latest Date 3

           

          PersonA     12/01/2016         12/01/2014         12/1/2011

           

          My current work looks like below using 4 columns

           

          1.Dimension

          Name

          2.Measure

          Max(Date)

          3.  Measure

          Unknown

          4. Measure

          Unknown