Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

ederleelefon_gt
New Contributor II

Rainbow/Triangle Summation in Qlik Sense

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

1 Solution

Accepted Solutions

Re: Rainbow/Triangle Summation in Qlik Sense

3 Replies

Re: Rainbow/Triangle Summation in Qlik Sense

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

ederleelefon_gt
New Contributor II

Re: Rainbow/Triangle Summation in Qlik Sense

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.

Community Browser