Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to calculate accumulation based on another calculated value and not the governing dimension

Hello,

I'm familiar with using RangeSum to calculate the accumulated values in a table (see expression below).

My problem is how do I calculate accumulation based on another calculated value/column instead of the governing dimension?

rangesum( above( sum([Expression1]),0,rowno()))

I hope you guys can help! Thanks!

Br, Alexander

2 Replies
BalaBhaskar_Qlik

May be try this:

Accumulation in Script

Anonymous
Not applicable
Author

I actually found the perfect solution in another thread after I posted this.

See here: https://community.qlik.com/blogs/qlikviewdesignblog/2013/12/09/pareto-analysis