Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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
balabhaskarqlik

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