Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
pranabdee
New Contributor II

How to retain data from a previous load to show trends?

Hello everyone! I'm fairly new to Qlik Sense. I need to do the following:

I have the following table

Risk:

Serial NoSupplier NameRisk Score
1A

8

2B4
3C10
4D2

This table is extracted from an excel file.

A new excel file will be loaded every week with changes in just the risk score column.

How do I retain the risk score values of the previous week, to show a trend in risk score of each supplier?

Any suggestions are greatly appreciated.

Best,

Pranab

Tags (2)
3 Replies
prithviram777
New Contributor III

Re: How to retain data from a previous load to show trends?

Hi Pranab,

It would be great if you can add a Date column or a month column to it and load it each month,

Or you can try creating a column for Month and go ahead.

Let me know if it would suit you.

Thank you

Highlighted
pranabdee
New Contributor II

Re: How to retain data from a previous load to show trends?

Hello Prithvi,

Even if I add a date/month column, when the user loads the new data from the excel file, wouldn't the previous data be removed from qlik?

This is what I wanted to do:

Say each week, a different version of the data is loaded (replacing the existing data). I want to find out the way to retain the risk score column of the existing data before it is discarded by qlik, so that it can be visualized along with the current data.

In the third week, when the newer set of data is loaded, the risk scores of week 1 are discarded, the risk scores of week 2 is retained and visualized along with week 3 data.

Is this possible in qlik?

Re: How to retain data from a previous load to show trends?

I can think, Find last week of data and load the same table of data by help of Variable which hold last week number. Then, Understand to define as Flag for that. And use same flag for reference which you need?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)