topic cumulative sum in QlikView

cumulative sum

doespirito — Thu, 19 Apr 2018 08:11:44 GMT

Hello,

For cash flow monitoring, I try to calculate a cumulative sum by adding an initial balance.

Can you help me realize that?

Here is a screenshot with the formula on excel tab.

I want to create the cumulative sum first. Then I will add the initial balance to this formula.

I enclose the qw file.

Thank you very much,

Arnault

sunny_talwar — Thu, 19 Apr 2018 11:30:56 GMT

Where do we get the starting cash number from? This is needed in addition to the total or the total can replace the starting cash row?

doespirito — Thu, 19 Apr 2018 12:25:13 GMT

two possibilities :

- add it in the formula (xxxxx + 700)

- put it in a variable

starting cash is needed in addition to the total and it gives final cash

final cash = starting cash + all movements i load in the application

Arnault

doespirito — Thu, 19 Apr 2018 16:13:21 GMT

i've finally used this expression

RangeSum(Above(TOTAL Sum(MontantK), 0, RowNo(TOTAL))) + 700

and it works fine,

even if I can not create a horizontal array...

Arnault