topic Percent Change in Graphs in QlikView

Percent Change in Graphs

Thu, 21 Jan 2010 05:37:55 GMT

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.

Percent Change in Graphs

Thu, 21 Jan 2010 07:49:52 GMT

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

So the expression would be:

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

Percent Change in Graphs

Fri, 22 Jan 2010 21:46:27 GMT

That works! Thanks.

Re: Percent Change in Graphs

rduvall33009 — Mon, 21 Jul 2014 17:51:30 GMT

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.