Store weekly data to track history

[Hoowling]

Hi community, 

I have a qlik that is loaded daily which shows forecasted production at the load date. 
This data is continuously changing as production orders are completed and new orders are created, meaning that the data is constantly overwritten. 

I want to be able track how the forecast changes - e.g. I want to be able to compare the forecast at week 1 with the forecast at week 2. Today I do this manually by storing the current week data in Excel and uploading it to the qlik. 

Is it possible to store the data upon reload into a QVD-file (preferably once a week to limit the number of qvd files created - the qlik is loaded daily) and dynamically including it in the qlik? 

Below is an example of what I hope to achieve:

[Taoufiq_Zarra]

Hi,

yes this is possible through " Insert and Update " using QVD files for incremental load

a sample code that you can use

QV_Table:

SQL SELECT your_PrimaryKey, WorkCenter,Week(today()) as week, forecast FROM yoursource

WHERE ModificationTime >= #$(LastExecTime)#;

 

Concatenate LOAD your_PrimaryKey, WorkCenter,week, forecast FROM history.QVD

WHERE NOT Exists(your_PrimaryKey);

 

STORE QV_Table INTO history.QVD;

more details in this section : link

then you can use history.QVD for your reporting

[Brett_Bleess]

Just adding a Design Blog post in addition to the Help link Taoufiq supplied, may be of some further help in getting it to make sense.

https://community.qlik.com/t5/Qlik-Design-Blog/Overview-of-Qlik-Incremental-Loading/ba-p/1466780

Regards,
Brett