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|
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.