Solved: Backup data in qlikview - Qlik Community - 1506941

Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Skip to main content

Qlik.com | Qlik Services| Qlik Help |

Ask a Question

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

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

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

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