Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Backup data in qlikview

Hi,

 

Could we backup old data before reload in qlikview. I need to compare the performance trend comparing old report and new report.

 

is it possible to reuse the old data and reloaded data at a time for representation.

1 Solution

Accepted Solutions
prieper
Master II
Master II

hmmm,

would think of a partial reload:

aircode:
STORE MyData Into MyOldData.QVD (QVD);

DROP TABLE MyData;

MyData: ADD LOAD * FROM ....;
(or use REPLACE LOAD ...)

and then reload the old data again and do a comparison on whatever field(s)

Peter

View solution in original post

2 Replies
ogster1974
Partner - Master II
Partner - Master II

Store your archive data in a QVD for use in comparison. 

prieper
Master II
Master II

hmmm,

would think of a partial reload:

aircode:
STORE MyData Into MyOldData.QVD (QVD);

DROP TABLE MyData;

MyData: ADD LOAD * FROM ....;
(or use REPLACE LOAD ...)

and then reload the old data again and do a comparison on whatever field(s)

Peter