Qvd - incremental store

[#1]

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]

Each day:

Load new data from DB

Concatenate load contents of QVD

Store results into QVD

[maxgro]

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 · Accepted solution]

Please go trough this Incremental Load

Vikas

[PradeepReddy]

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;

[#6]

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

Do you know how could I?

Best regards, Luiz