Second Max of Date

[sspawar88]

Hi Community,

How Can i Select Second Max Value in Qlikview by Date_ID?

Date_ID	Date
275	04/03/2016
247	22/04/2016
255	20/05/2016

[sunny_talwar]

Here there are only one Date_ID, but if there were more then 1, you can use this: Max(Date, 2)

[amit_saini]

Hi,

Try:

Last Date:  Date(max(Date_Field),'DD/MM/YYYY')

Last Previous Date: Date(max(Date_Filed)-1,'DD/MM/YYYY')

Thanks,

AS

[swuehl]

FirstSortedValue(DISTINCT Date, -Date, 2)

[sunny_talwar]

Stefan - why not use Max() here? Is there a benefit of using FirstSortedValue() over Max()?