Cumalative/running total - Qlik Community

asinghal0412 · ‎2021-05-20

Dear Qlik Community,

I have a table below,

In the last column, I am trying to get the cumulative total of the 3rd column.

My current code is:

RangeSum(Above(TOTAL Sum([Net VAVE (Calculated)]), 1, RowNo(TOTAL)))

but as you can see in the table the values are zero.

Can any1 help me with the code?

Thanks,

Akash

MayilVahanan · ‎2021-05-20

Try like below

RangeSum(Above(Total Sum([Net VAVE (Calculated)]),0, RowNo(Total)))

o/p:

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

asinghal0412 · ‎2021-05-20

I tried your code, It gives an error message.

Did you change the 3rd column as well?

Akash

MayilVahanan · ‎2021-05-20

Instead of "Sum([Net VAVE (Calculated)])", you can change use ur expression.

If it still shows error, pls provide the sample file

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.