Cumulative in the same graph? - Qlik Community

alboreal · ‎2011-12-15

I have a graph of cumulative sales and want to represent their variation on the same graph. I can not get properly calculate the variability of the accumulated data.

February is the incremental (573 of 526) 8.9% and 11.2% as the chart says.

Thanks.

PVM

Miguel_Angel_Baeyens · ‎2012-01-03

Hi,

How are the expressions you are using in the chart? Are you using the "Full Accumulation" in the Expressions tab for all the expression?

Regards,

Miguel

alboreal · ‎2012-01-04

Hi Miguel.

When I calculate the differential and use “Full Acumulation” Qlikview adds increased each month differenctial.

Ene: 172935 / 142886 = +21.03%

Feb: 343935 / 275313 = +24.92%

Why 50.16% ????

Thanks,

Pedro