Store in QVD with Incremenatal Load

[#1]

Hi Experts,

I have a requirement like, have to store data in QVD's by monthly with incremental load. How to achieve this?

Thanks,

[swuehl]

Download the delta load (incremental load) template from Rob Wunderlich's QV cookbook site:

http://qlikviewcookbook.com/download/delta-load-template/‌‌

It does a very good job in explaining the principles of an incremental load (see the script section of the QVW).

Hope this helps,

Stefan

[avinashelite]

check this links for more information

Create Monthly QVD's

http://www.learnqlickview.com/a-qlikview-qvd-function-to-simplify-incremental-data-load/

[Anonymous]

Hi

Check this link

storing data into qvd in monthly basis

[Chanty4u]

chk dis

storing data into qvd in monthly basis

Loading Multiple QVD files

[jagan · Accepted solution]

Hi,

Check this

https://www.resultdata.com/qlikview-incremental-loads-and-qvds/

Data:

LOAD

*

FROM DataSource

WHERE MonthName(DateFieldName) = MonthName(Today());

LET vCurrentMonth = MonthName(Today());

STORE Data INTO [$(vCurrentMonth).qvd];

Like this create qvd for every month.

Regards,

Jagan.