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

[alsahly2017]

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).

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

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  😁 .

[martinpohl · Accepted solution]

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]

Thank you so much for helping and supporting 

It works perfectly