Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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