Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 😁 .
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
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
Thank you so much for helping and supporting
It works perfectly