Discussion board where members can get started with Qlik Sense.
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.
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.
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