Discussion board where members can get started with QlikView.
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
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..
Go to Solution.
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.
Gysbert, thanks for this! it headed me in the right direction... I ended up using this: