Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
alsahly2017
Contributor III
Contributor III

how to store a historical data from an existing in qlik sense

Hello and welcome 😊,

I hope you are doing well,

I have an exported excel file  from database automatically , all of this file's data is changeable (  the file could be empty sometime).

clipboard_image_0.png

 

the current situation is that the code ( second table) will be shown the current blocked users (block=1)  and not the historical blocked users:

clipboard_image_2.png

clipboard_image_3.png

So , if the blocked users disappeared from the first table(database resource) it will disappeared from the another which is NOT what I want,what I need is that a table can save all users which have block =1 and store it in another table in qlik sense even if the original table is empty.

 

Thank you  😁 .

Labels (1)
1 Solution

Accepted Solutions
martinpohl
Partner - Master
Partner - Master

so store your data each day into new files

let vName=date(today(),'YYYYMM');

store table into [lib://test.test_$(vName).qvd] (qvd);

and load all datas into your application

load * from 

[lib://test.test_*.qvd] (qvd);

Regards

View solution in original post

2 Replies
martinpohl
Partner - Master
Partner - Master

so store your data each day into new files

let vName=date(today(),'YYYYMM');

store table into [lib://test.test_$(vName).qvd] (qvd);

and load all datas into your application

load * from 

[lib://test.test_*.qvd] (qvd);

Regards

alsahly2017
Contributor III
Contributor III
Author

Thank you so much for helping and supporting 

It works perfectly 

 

clipboard_image_0.png