Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
this might be helpful:
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,
what do you want max(date)-1 or 2nd maximum value
use max(date,2) in suggested solution.
Regards,