How to load Max(Date) and Max(Date)-1 qvds

[mahitham]

Hi Experts,

Can any one please help me on below requirement.

In C:/Qliksharefolder/4.QVDs path I have number of qvds with date like below.

All these qvds contains same columns with different data.

kensitivities_Detail_20180520.qvd

Kensitivities_Detail_20180521.qvd

Kensitivities_Detail_20180616.qvd

Kensitivities_Detail_20180617.qvd

From these qvds I have to load only Max(date) and Max(date)-1 qvds dynamically in the load script instead of Kensitivities_Detail_*.qvd

Please help me on this.

Thanks in advance.

[Frank_Hartmann]

this might be helpful:

How to load latest excel from the folder

[mahitham]

Hi Frank,

The above link example contains only to load max(date) file I am looking for how to load both max(date) and max(date)-1 qvds.

Thanks,

[PrashantSangle]

what do you want max(date)-1 or 2nd maximum value

use max(date,2) in suggested solution.

Regards,