topic Re: Accumulative Vs Cumulative in QlikView

Accumulative Vs Cumulative

nihhalmca — Tue, 21 Jul 2015 10:50:07 GMT

Hi All,

Can any body share knowledge on Accumulative Vs Cumulative with example.

Thank you.

Regards,

Nihhal.

krishna20 — Tue, 21 Jul 2015 10:58:32 GMT

Hi,

Pls find here

jagan — Tue, 21 Jul 2015 10:59:03 GMT

Hi Nihhal,

Both are same, I think they are synonyms.

Regards,

Jagan.

nihhalmca — Tue, 21 Jul 2015 11:04:34 GMT

Hi Jagan,

Thank for reply.

There is option for Accumulative in chart properties, however i have seen some posts for cumulative writing below script what is difference here.

ex: Rangesum(above(sum(sales),0,rowno()) as expression

Regards,

Nihhal.

MK_QSL — Tue, 21 Jul 2015 11:28:01 GMT

Both are same...

But I think in pivot Table, you don't have option of accumulation which is available in Straight Table. You need to use

RangeSum(Before(SUM(Sales),0,RowNo()))

jagan — Tue, 21 Jul 2015 11:32:22 GMT

Both are same but doing in script sometimes for specific purposes.

nihhalmca — Tue, 21 Jul 2015 14:55:10 GMT

Thanks Manish.