Cumulative Sum of a Column

Rdelavega — Sat, 16 Nov 2024 03:06:51 GMT

Hello,

I learned in this forum that the fuction "RangeSum" combined with "Above" can cumulative sum a column, however this is not working for me and i wanted to ask for your help.

In the image you can see two columns with ID and client Name. next I have 2 more columns with money sent and money received. next column would be the column(2)-column(1) result (received - sent) and in the last column I want to show the cumulative result of (received - sent). unfortunately, it seems i'm worng in the formula and the last column is showing Column(3) instead.

the formula i'm using is Rangesum(Above(Column(3),0,RowNo())). I also tried with Rangesum(Above(SUM(Column(3)),0,RowNo())) but i does not work either.

thanks in advance for your help

Re: Cumulative Sum of a Column

Frank_Hartmann — Tue, 02 Jul 2019 16:53:03 GMT

have a look here:

https://community.qlik.com/t5/QlikView-Creating-Analytics/How-can-you-use-SUM-Column-n/td-p/1057000

topic Re: Cumulative Sum of a Column in QlikView

Cumulative Sum of a Column

Re: Cumulative Sum of a Column