Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How can I store the data in Qlikview and retrieve it to compare it with the new refreshed data ?

I want to create a graph which shows a comparison between the new and old data.

How can I achieve this in Qlikview?

In the snap attached (Excel graph), WK-8 is the old data and WK-9 is the new refreshed data.

3 Replies
bramkn
Partner - Specialist
Partner - Specialist

Use a flag for the old and new data Example: 'WK-8' AS DataFromWK for old data and 'WK-9' AS DataFromWK for new data

Anonymous
Not applicable
Author

I did not understand.

Where shall I store the old data in,as new data will be refreshed periodically ?

bramkn
Partner - Specialist
Partner - Specialist

Is it new transaction data for the following weeks? or is data from past weeks changing?

If it is just new data from the following weeks just use a calendar with weeks to determine from which week the data is.

If the past data is changing you need to create a field and tell it what kind of data it is.