topic Re: Running total/Cumulative in pivot Chart in QlikView

Running total/Cumulative in pivot Chart

gouthamkk — Mon, 16 Jun 2014 19:48:26 GMT

HI,

I am trying to get cumulative total for net column, My calculation in (In - Out) + Previous Net(Running total) for each group.

I tried using Range sum and above functions, getting only the value of previous row but not as a cumulative/ running total.

If used in a straight table, by selecting Full Accumulation, i could achieve it. But my scenario is to use a pivot table.

Request for assistance.

jerem1234 — Mon, 16 Jun 2014 19:54:39 GMT

Used this formula:

rangesum(above(total In - Out, 0, rowno(total)))

Please find attached.

Hope this helps!

jerem1234 — Mon, 16 Jun 2014 19:57:48 GMT

If you want running totals for each group, just take total out like:

rangesum(above(In - Out, 0, rowno()))

gouthamkk — Mon, 16 Jun 2014 19:59:58 GMT

Really appreciate it.

sorry to not mention, The running total hast to occur for each group, not for entire table, Is it possible to get the running total group wise?

jerem1234 — Mon, 16 Jun 2014 20:02:52 GMT

Should be able to use:

rangesum(above(In - Out, 0, rowno()))

like I mentioned above.

If not, can you give an example of the output you want? What numbers are you expecting for your example?

gouthamkk — Mon, 16 Jun 2014 20:04:52 GMT

Thanks Jerem