Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

gouthamkk
Contributor

Running total/Cumulative in pivot Chart

Test.PNG.pngHI,

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.

1 Solution

Accepted Solutions
jerem1234
Valued Contributor II

Re: Running total/Cumulative in pivot Chart

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

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

5 Replies
jerem1234
Valued Contributor II

Re: Running total/Cumulative in pivot Chart

Used this formula:

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

Please find attached.

Hope this helps!

jerem1234
Valued Contributor II

Re: Running total/Cumulative in pivot Chart

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

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

gouthamkk
Contributor

Re: Running total/Cumulative in pivot Chart

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
Valued Contributor II

Re: Running total/Cumulative in pivot Chart

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
Contributor

Re: Running total/Cumulative in pivot Chart

Thanks Jerem

Community Browser