Solved: Select Date in a column - Qlik Community

Report Inappropriate Content · ‎2012-10-17

Hi all, please help if you can

I need a way to find the second highest value in a date range.

So if this is the Table

Date

17/10/2012

14/10/2012

13/10/2012

11/10/2012

05/10/2012

I would want the formula to return 14/10/2012...

I might be over thinking this but I am not sure how to do this..

Thanks

Gysbert_Wassenaar · ‎2012-10-17

Try this: =date(FirstSortedValue( [Date],-[Date],2),'DD/MM/YYYY')

Also make sure your date is really a date and not text. Use the date# function if necessary.

talk is cheap, supply exceeds demand

Gysbert_Wassenaar · ‎2012-10-17

Try this: =date(FirstSortedValue( [Date],-[Date],2),'DD/MM/YYYY')

Also make sure your date is really a date and not text. Use the date# function if necessary.

talk is cheap, supply exceeds demand

Report Inappropriate Content · ‎2012-10-17

Gysbert, thanks for this! it headed me in the right direction... I ended up using this:

=FirstSortedValue(DISTINCT [Date],-[Date],2)

Select Date in a column