topic Accumulation for Pivot Table in QlikView

Accumulation for Pivot Table

Thu, 31 Jan 2013 10:18:29 GMT

Hi,

There is an option to do the accumulation in the QlikView using straight table.

Similarly is there is any option to do the accumulation for Pivot Table.

Thanks,
Sijo Joseph

Thu, 31 Jan 2013 10:22:09 GMT

for accumulation try this

rangesum(above(sum(Amount), 0 , RowNo())))

Gysbert_Wassenaar — Thu, 31 Jan 2013 10:24:02 GMT

No, you'll have to do it in the expressions using rangeXXX functions and the above (or below) functions.

Thu, 31 Jan 2013 11:20:30 GMT

Thanks it worked.. I will do some more testing with it

Thu, 31 Jan 2013 11:21:56 GMT

Thanks..