Load QVDs into QlikView based on last modified date

[Anonymous]

Hello All,

I have monthly QVDs from 2016 to till date.

Data is stored into QVD based on Month. So I have 19 monthly wise QVDs.

I am showing the data from 2016 till date on the QlikView Application So I am loading the data from QVDs using * to load all the QVDs into QV.

Only current month and previous months QVDs only will be refreshed everyday.

In this case I don't have to load the data from all the historical QVDs into QV Dashboard everyday. But I should show the data from 2016 till date on the QV Application.

Only current and previous months QVD should load. So I can reduce the reload time.

Can anyone suggest me how to achieve this?

Thanks,

Nisha

[tresesco]

You may try with Partial Reload ‒ QlikView

[Siva_Sankar]

Incremental Load in Qlikview - Sources

[techvarun]

Try this script

for each File in filelist ('C:\My Documents\Test\*.TXT')

Folder:

Load '$(File)' as Name,

FileTime( '$(File)' ) as FileTime,

Filename() as Source

autogenerate 1;

next File

LatestFile:

first 2

Load

Name,

FileTime,

1 as dummy

Resident Folder

Order By FileTime DESC;

drop table Folder;

Source : Load the latest file of a folder

//Code Modified to pick the latest two files from the folder//