topic Re: Cumulative in the same graph? in QlikView

Cumulative in the same graph?

alboreal — Thu, 15 Dec 2011 09:02:21 GMT

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

Cumulative in the same graph?

Miguel_Angel_Baeyens — Tue, 03 Jan 2012 17:34:49 GMT

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

Re: Cumulative in the same graph?

alboreal — Wed, 04 Jan 2012 13:29:32 GMT

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