How to calculate top n minimum date

[sarfaraz_sheikh]

Dear All,

select min(renewalbase) from (select DISTINCT top 3 [renewalbase] from STP_LMS_Lead (NoLock) order by renewalbase desc) a)

how i can achive the above sql code in qlikview  [ RenewalBase is date field ]

Sarfaraz

[Gysbert_Wassenaar · Accepted solution]

LOAD

     max(renewalbase,3) as ThirdLargestValue

FROM ...

[sarfaraz_sheikh]

Dear Gysbert,

Thanks for your solution ...it is working as expected brilliant..

Sarfaraz