Rainbow/Triangle Summation in Qlik Sense

[ederleelefon_gt]

Hi Qlik Community,

I would like to ask if you can suggest possible approach in achieving this kind of computation in Qlik Sense,

This is an accumulative, that carries balance from OrigVal + Jan then carries that total forwarding the computation. It's like a Triangle summation. Any ideas or document reading is much appreciated.

OrigVal + Jan

OrigVal+ Jan + Feb

OrigVal+ Jan + Mar

OrigVal+ Jan + Mar + Apr

OrigVal+ Jan + Mar + Apr + May

OrigVal+ Jan + Mar + Apr + May + June

OrigVal+ Jan + Mar + Apr + May + June + July

OrigVal+ Jan + Mar + Apr + May + June + July + Aug

OrigVal+ Jan + Mar + Apr + May + June + July + Aug + Sep

OrigVal+ Jan + Mar + Apr + May + June + July + Aug + Sep + Oct

OrigVal+ Jan + Mar + Apr + May + June + July + Aug + Sep + Oct + Nov

OrigVal+ Jan + Mar + Apr + May + June + July + Aug + Sep + Oct + Nov + Dec

OrigVal+ Jan + Mar + Apr + May + June + July + Aug + Sep + Oct + Nov + Dec + 13 +14+15+16

Thank you

[sunny_talwar]

Seems like a cumulative sum, isn't it? Do you need this in the script or front end of the app?

[sunny_talwar · Accepted solution]

Here are couple of documents on how to do this in the script

https://www.quickintelligence.co.uk/qlikview-accumulate-values/‌

Qlikview : Generate a running total column in load script | Qlikview Tips

[ederleelefon_gt]

Hi Thank you so much for you reply will take a look at it, I need to do it on the backend this will serve as balance forward for accounting report.