Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Select Date in a column

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

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Select Date in a column

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
2 Replies
MVP & Luminary
MVP & Luminary

Re: Select Date in a column

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
Not applicable

Re: Select Date in a column

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

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