Create a loop to load only 4 last weeks of data

[QVUser1]

Hi Team,

I want to create a loop while loading data that it should take only last 4 weeks of the data into app.Where my qvd names are created as shown below:

[Iswarya_]

Hi @QVUser1 

Try like this below:

FOR EACH vFile IN FILELIST ('lib://Test/CountrySales_*.qvd')
IF(num(DATE#(TextBetween(vFile,'_','.'),'YYYY-MM-DD')) >= TODAY() - (4*7)) THEN

Data:
LOAD *,
FileName('$(vFile)') as QvdName
FROM [$(vFile)](qvd);
END IF
NEXT vFile

[QVUser1]

What is this vFile is this any variable .if so what should we declare in it.