Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
DipeshVadgama
Partner - Creator II
Partner - Creator II

Save Shapshot of data

Hi All,

I am not sure weather this is possible or not.

I have simple data load and I have created table in Qlikview document. I would like to take a snapshot of table numbers and save it on each day. like below.

Yesterday

Today

I would need result as below ( Its fine if its create new Qlikview file or new separate table )  

   

DataCAOCPRPhAOPhPRMTCHMTPPMTCHMTPDate
Studio Data3582989111029-Nov-17
Studio Data52541913911030-Nov-17
3 Replies
Clever_Anjos
Employee
Employee

You can at script level

  • Calculate your values
  • Load previous values from a file (csv)
  • Store the new values into same file
DipeshVadgama
Partner - Creator II
Partner - Creator II
Author

Thanks can you share me example please 🙂

YoussefBelloum
Champion
Champion

Hi,

you can make this:

before your LOAD:

Let vToday = DATE(Today(),'DDMMYYYY');

after your LOAD:

store TABLE into 'PATH\TABLE_$(vToday)' (txt);