Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Person | Date | Count | Person A | Latest 3 Dates | ||
PersonA | 12/01/2013 | PersonA | 7 | 1 | 12/1/16 | |
PersonB | 12/03/2014 | HELP | ||||
PersonC | 12/05/2014 | HELP | ||||
PersonD | 12/06/2017 | |||||
PersonA | 12/01/2016 | |||||
PersonB | 12/03/2014 | |||||
PersonC | 12/05/2014 | |||||
PersonD | 12/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
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