topic QVD File updation. in QlikView

QVD File updation.

vijayit43 — Wed, 08 Apr 2015 10:18:42 GMT

Hi Expert,

We are creating a Dashboard we want to fetch data from current month to server and other data from QVD file how to create QVD and reload schedule to QVD Dynamically to update previous month data.

please suggest with example

Re: QVD File updation.

Anonymous — Wed, 08 Apr 2015 10:45:12 GMT

Hi,

Use incremental load code below:

//First load current month data.
//So that we will read the records where modification time is greater than or equal to last execution time.
//After we load previous month data from existing QVD and Concatenate to the current month data and store it into QVD

Table:
SQL SELECT PrimaryKey, X, Y FROM DB_TABLE
WHERE ModificationDate >= $(LastExecTime);
Concatenate
LOAD PrimaryKey, X, Y FROM Data.QVD;
STORE Table INTO Data.QVD;

Regards

Neetha

Re: QVD File updation.

Anonymous — Wed, 08 Apr 2015 10:54:06 GMT

Find attached incremental load script and modify as your need.

Thanks

BKC