Percent Change in Graphs

[#1]

Hi,

I'd like to display the percentage change of an amount column in a line graph. I know I can calculate percent change in a pivot table with time as the dimension and something like

=sum(amount) / before(sum(amount)) - 1

as the expression but the before function only works in a pivot table. Is there an equivalent function or expression that I can use for other types of charts?

I am using QlikView 9.

Thanks.

[#2 · Accepted solution]

The above () function works in the Line charts!!!

So the expression would be:

=sum(Amount)/above(sum(Amount))-1

[#3]

That works! Thanks.

[rduvall33009]

I know this is an older post but how would you compare to the first value.  This would show how each month was compared to the first month/reading?  I thank you advance for your time and assistance.