topic Re: Store weekly data to track history in QlikView

Store weekly data to track history

Hoowling — Sat, 16 Nov 2024 01:39:10 GMT

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:

Re: Store weekly data to track history

Taoufiq_Zarra — Fri, 20 Dec 2019 15:00:41 GMT

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

Re: Store weekly data to track history

Brett_Bleess — Thu, 26 Dec 2019 15:17:05 GMT

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