Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Not applicable

Store in QVD with Incremenatal Load

Hi Experts,

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

Thanks,

Tags (1)
1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: Store in QVD with Incremenatal Load

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.

View solution in original post

5 Replies
Highlighted
MVP
MVP

Re: Store in QVD with Incremenatal Load

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

Highlighted

Re: Store in QVD with Incremenatal Load

Highlighted
rgvavihs
Valued Contributor

Re: Store in QVD with Incremenatal Load

Highlighted
Chanty4u
Esteemed Contributor III

Re: Store in QVD with Incremenatal Load

Highlighted
MVP & Luminary
MVP & Luminary

Re: Store in QVD with Incremenatal Load

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.

View solution in original post