topic Accumulation in pivot/table chart in QlikView

Accumulation in pivot/table chart

Fri, 05 Feb 2010 17:32:52 GMT

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

Accumulation in pivot/table chart

johnw — Fri, 05 Feb 2010 21:29:06 GMT

I think this:

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

Accumulation in pivot/table chart

Sat, 06 Feb 2010 15:02:14 GMT

Hi,

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

Accumulation in pivot/table chart

johnw — Sat, 06 Feb 2010 20:36:33 GMT

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.