Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
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