Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Seems like a cumulative sum, isn't it? Do you need this in the script or front end of the app?
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
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.