topic Re: How to load Max(Date) and Max(Date)-1 qvds in QlikView

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

mahitham — Wed, 25 Nov 2020 16:16:04 GMT

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 — Tue, 19 Jun 2018 12:25:39 GMT

this might be helpful:

mahitham — Tue, 19 Jun 2018 12:31:45 GMT

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 — Tue, 19 Jun 2018 12:39:07 GMT

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

use max(date,2) in suggested solution.

Regards,