topic Re: Dynamically update in QlikView

Dynamically update

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

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.

Re: Dynamically update

Gysbert_Wassenaar — Fri, 14 Dec 2018 15:21:45 GMT

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);

Re: Dynamically update

dplr-rn — Fri, 14 Dec 2018 15:40:45 GMT

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)