Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
I did not understand.
Where shall I store the old data in,as new data will be refreshed periodically ?
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.