Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

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 (2)
1 Solution

Accepted Solutions
Partner
Partner

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
Partner
Partner

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

Contributor II
Contributor II

Thank you so much for helping and supporting 

It works perfectly 

 

clipboard_image_0.png