I am an entry level Qlikview user and I need to reflect market share for a range of products on a graph - the problem comes in when I also have to add the change of the current market share vs the previous market share on the same graph.
Is this possible?
How would I go about doing this?
You can use the above() function to retrieve the value of a previous row. Perhaps you can add a second expression to your chart to calculate the change. Something like
First expression; Market Share: sum(MarketShare)
Second expression; Change: above(sum(MarketShare))/sum(MarketShare) -1
Retrieving data ...