Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
The above () function works in the Line charts!!!
So the expression would be:
=sum(Amount)/above(sum(Amount))-1
The above () function works in the Line charts!!!
So the expression would be:
=sum(Amount)/above(sum(Amount))-1
That works! Thanks.
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.