Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Note: You may notice some temporary visual or styling issues in the Community. Our vendor is actively investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Incremental recharge

Hello good day,

I would like to know as I can, store data daily in a QVD file, without data being lost the day before.

Example

SQL Select * from clickvtemuco;

STORE Table1 into Tabla1.qvd (QVD);

to reload the new data the previous day day lost

1 Reply
JonnyPoole
Former Employee
Former Employee

You need to concatenate the QVD based history first

Tabla1:

Load *

from <QVD>;

concatenate (Tabla1)

SQL Select * from clickvtemuco;

STORE Table1 into Tabla1.qvd (QVD);

Then you are always adding.  The are more incremental scenarios in the qlikView product help under "QVDs and incremental loads" help topic.