Percentage with full accumulation

Fri, 26 Apr 2013 13:29:57 GMT

Hi guys,

Question concerning the full accumulation option.

I have a graph with sum(Sales), accummulated over the year (option full accumulation)

I already have the difference between years (same month, but year -1).

I now want to show the accummulated difference, but this is where Qlikview does strange things.

I am using the expression:

=(sum({$<Month=, Year={$(=only(Year))}>}Sales)
/
sum({$<Month=, Year={$(=only(Year)-1)}>}Sales))
-1

As you can see, it does not show me the correct value. The percentage for april should be:

(8.712.137/15.331.837)-1 = -43% and not -183%??

Thanks for your help!

Zipke

topic Percentage with full accumulation in QlikView