Dynamically update

[has75042]

Hey Everyone,

I have a report which I have to update start of every period. Is there a way I can dynamically change it so it picks up the next period.

Please see the attached file.

[Gysbert_Wassenaar]

for each vFile in filelist ('E:\Qlikview\QVD\*.qvd')
    // do nothing, just iterate through the files
next 

// now vFile will contain the name of the newest file
LatestFile:
LOAD * FROM [$(vFile)] (qvd);

[dplr-rn]

Whats the logic of storing the name of the qvd. Use it as part of your load. Something like below

let vQvdName='xyz'&Date(today(),'DD-MM-YYYY')&'.qvd';
xyz:
LOAD *
FROM
[QVDFOLDER\$(vQvdName)]
(qvd)