Solved: Accumulation in pivot/table chart - Qlik Community

Report Inappropriate Content · ‎2010-02-05

Hi *,

I'm using a pivottable that looks like this:

How can I do a accumulate the values:.

-> 01.01.2010: 10
02.01.2010: 0
03.01.2010: 15

....

Thanks for your help.

Regards
Aloah

johnw · ‎2010-02-06

Oops! Do this:

rangesum(sum(Value),above(Kumulation))

You're adding the current sum(Value) to the Kumulation from the above row. The way I gave it to you the first time was only adding to the sum(Value) of the above row, which wasn't what I intended, and as you see, doesn't give the result you want.

View solution in original post

johnw · ‎2010-02-05

I think this:

rangesum(sum(Value),above(sum(Value))

Report Inappropriate Content · ‎2010-02-06

Hi,

with rangesum I get this 10, 0, 5.... instead of 10, 0, 15...

johnw · ‎2010-02-06

Oops! Do this:

rangesum(sum(Value),above(Kumulation))

You're adding the current sum(Value) to the Kumulation from the above row. The way I gave it to you the first time was only adding to the sum(Value) of the above row, which wasn't what I intended, and as you see, doesn't give the result you want.