Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

leefraser
New 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
New Contributor II

Re: Working With Dates

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

Community Browser