topic Bar Chart Difference in QlikView

Bar Chart Difference

Tue, 07 Feb 2012 16:47:52 GMT

Hi All,

I have the following bar chart.

In the Y axis I have the amount of money spent.

In the X axis I have the Year.

I would like to know which is the function to calculate de difference between one year and another.

lets suppose that in 2011 I spent $100 and on 2012 I spent 200, I want the function that brings to me 200 - 100 = 100 automatically. (as another bar in the chart)

For total accumulated I use rangesum(above).... but for the difference I don't know which is the function..

thank you all ...

Bar Chart Difference

swuehl — Tue, 07 Feb 2012 16:59:28 GMT

You could look into the chart inter record functions, one of them is the above() function you already used.

So try something like

=Sum(Value)-above(Sum(Value))

as expression for your Delta bar.

Bar Chart Difference

Tue, 07 Feb 2012 17:13:07 GMT

You re right...

It was just in front of my eyes....

Really thanks.