topic Re: how to drop old qvds in QlikView

how to drop old qvds

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

Hi,

I have number of qvd's in particular folder for reference i added below image

from here I need last 5 days QVDs only for example from current date qvd to last 5 days qvd. In below i attached my expected output image

Help me to handle in script. thanks in advance

thanks,

yuvaraj G

sunny_talwar — Tue, 02 May 2017 18:59:00 GMT

Look here for your options

Anonymous — Tue, 02 May 2017 23:14:34 GMT

sunny,

give me any alternate solution its difficult to understand

Anil_Babu_Samineni — Wed, 03 May 2017 01:51:38 GMT

May be this? Make sure, to change as per your date format which is comment as below

SET DateFormat = 'MMDDYYYY';

SET vRoot = 'C:\myfolder';

FOR Each File in filelist ('$(vRoot)'&'\*.'&qvd);

FileName:

Load Replace(SubField('$(File)', '_', 2),'.qvd','') as Name;

// Load Date(Date#(Replace(SubField('$(File)', '_', 2),'.qvd',''),'MMDDYYYY'),'DD-MM-YYYY') as Name;

next File;

Load * Resident FileName where Name > Today()-5 and Name <= Today();