Compare todays data with the last working days

[RichardLee]

I have a script that pulls from multiple sources to create one Data Table. This is then put into multiple reports.

is there a way to store the data so that the next day I can bring it into the sheet to compare and analyse any movement in the data? 

[edwin]

this sounds like a job for an ETL and not for Qlik.  regardless, if you are able to attach a row identifier to both data sets then you can right join the old data set to the new data set and then compare specific fields.  you will be able to identify records that are didnt change, changed, and new.  if you expect records to fall off, you need to do a full outer join.  

of course to achieve this your identify field(s) should be the same and all other fields need to be renamed.

[vinieme12 · Accepted solution]

Yes you can, 

Everyday save your data with an additional field that determines which day the data was loaded

Sonyou can use this field to track daily changes to the data

Example;

Dailysnapshot:

Load *

,today() as snapshotdate 

from yoursource

;

Concatenate 

Load * from somepath/dailysnapshot.qvd;

Store Dailysnapshot into somepath/dailysnapshot.qvd;

Keep Adding your dailysnapshots in one qvd to create an "AsOf " dataset