Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Incremental Load from QVW

Hey Everyone.

First let me paint the picture:

I have 1200 XML's daily which i load into a file named Database.qvw

I have created a second file named CreateQVD.QVD (will only use it once)

In this file i create the QVD database for all my data.

Now i want to report over this in a third file named: Report.qvw.

So i can simply load the QVD files into my Report.qvw.

however tomorrow i will have another 1200 XML's.

These again will be loaded into Database.qvw so tommorow when updating my Report.qvw i need it to:

1, Load the old QVD

2, Incremental Load the Database.qvw

3, save a new QVD over the old one.

The reason i want to do it this way is because we would like to delete the XML's after a given time while still keeping the data in a QVD.

This is because on a yearly basis we would receive 438 000 XML's wich would be a pain to the server.

Could anyone help me with the syntax for this?
Do i need to binary load the Database.qvw or how can i achieve this?

3 Replies
buzzy996
Honored Contributor II

Re: Incremental Load from QVW

try this,

Could anyone help me with the syntax for this? ----PFA



Do i need to binary load the Database.qvw or how can i achieve this? --No need.

Not applicable

Re: Incremental Load from QVW

I have read that file already, still don't know which scenario i need to use.

buzzy996
Honored Contributor II

Re: Incremental Load from QVW

try this,

1. u can follow scenario 1 for incremental aggregation on ur Database.qvw

2. create ,store and refresh ur qvd "CreateQVD.QVD" after daily data load inserted into Database.qvw

3. use CreateQVD on ur final application.

Community Browser