Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qvd - incremental store

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

1 Solution

Accepted Solutions
vikasmahajan

Please go trough this Incremental Load

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

View solution in original post

5 Replies
m_woolf
Master II
Master II

Each day:

Load new data from DB

Concatenate load contents of QVD

Store results into QVD

maxgro
MVP
MVP

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

Please go trough this Incremental Load

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
PradeepReddy
Specialist II
Specialist II

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;

Not applicable
Author

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

Do you know how could I?

Best regards, Luiz