topic Re: Qvd - incremental store in QlikView

Qvd - incremental store

Tue, 08 Mar 2016 18:09:25 GMT

hello, everyone!

My database is dynamic and contains information of only one day (d-1).

I'd like to show the daily evolution of sales throughout the month.

I have a chart, a table actually, which is filled with daily sales results by product and I was thinking in store that table into a qvd

And everyday that qvd should be incremented with new information, but the past should not be delete.

There is a possibility to do it? how?

Sincerely, Luiz

m_woolf — Tue, 08 Mar 2016 18:47:01 GMT

Each day:

Load new data from DB

Concatenate load contents of QVD

Store results into QVD

maxgro — Tue, 08 Mar 2016 19:20:50 GMT

search incremental in the QlikView help

you'll find some example

from case 2 (I think you don't need the WHERE ......)

QV_Table:

SQL SELECT PrimaryKey, X, Y FROM DB_TABLE

WHERE ModificationTime >= #$(LastExecTime)#

AND ModificationTime < #$(BeginningThisExecTime)#

;

Concatenate LOAD PrimaryKey, X, Y FROM File.QVD;

STORE QV_Table INTO File.QVD;

vikasmahajan — Wed, 09 Mar 2016 06:35:42 GMT

Please go trough this Incremental Load

Vikas

PradeepReddy — Wed, 09 Mar 2016 07:09:03 GMT

Try like this..

DB_Table:

SQL select * from DB_Table_Name;

Concatenate

Load * from QVD_File_Name.qvd(QVD);

STORE DB_Table into QVD_File_Name.qvd;

Wed, 09 Mar 2016 19:29:34 GMT

But I want to store an object into a qvd, a chart.

Do you know how could I?

Best regards, Luiz