Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
EmmaG
New Contributor

Create new lines in a Qlik Sense table with old data that have been deleted

Hello,

I'm new on Qlik Sense and I'm searching a solution to my problem since several days... I really hope that someone will be able to help me !

I have an Excel file which contains Status data for different tasks :

1.PNG

 

 

 

 

 

I've created a table on Qlik Sense which is able to calculate the number of task by Status :

2.PNG

 

 

The goal is to follow all the Status regularly (usually every day) and store old data.

Tomorrow, if I open again my Excel file, the Status will be different (my Excel file is an extract from a database) :

3.PNG

 

 

 

 

 

My Qlik Sense application is refreshed every night so I will have this result tomorrow :

4.PNG

 

 

What I would like to have is a storage of all data on different lines :

5.PNG

 

 

I've tried a lot of different functions (buffer, add, concatenate, store) but it never worked...

The main problem is that the old Status' data are deleted every day as they change. It means that tomorrow I will have no copy of the first board with Status information of yesterday.

The final idea is to represent the evolution of tasks' Status on a bar chart, keeping the last information on Status for each month. It means that my application will refresh tasks' Status on the same line during 30 days and when a new month begins it will create a new line and refresh data on the same line during 30 days again etc...

 

Is there any function on Qlik Sense that is able to create a new line on a table (or on a .qvd) after every refresh of the application ?

 

I really hope that I was clear in my explanation,

Thank you in advance for your help,

Emma