Dashboard Graph reflecting Market Share and Market Share change

[#1]

Hi,

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?

Thanks

D

[Gysbert_Wassenaar]

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