topic Rainbow/Triangle Summation in Qlik Sense in App Development

Rainbow/Triangle Summation in Qlik Sense

ederleelefon_gt — Fri, 16 Feb 2018 06:56:17 GMT

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

Re: Rainbow/Triangle Summation in Qlik Sense

sunny_talwar — Fri, 16 Feb 2018 10:47:02 GMT

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

Re: Rainbow/Triangle Summation in Qlik Sense

sunny_talwar — Fri, 16 Feb 2018 10:48:01 GMT

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

Re: Rainbow/Triangle Summation in Qlik Sense

ederleelefon_gt — Sat, 17 Feb 2018 03:36:33 GMT

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.