Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
leefraser
Contributor II
Contributor II

Working With Dates

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

1 Reply
leefraser
Contributor II
Contributor II
Author

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