Qlik Community

Qlik Sense App Development

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

alexpetersen
New Contributor

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
Honored Contributor

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

May be try this:

Accumulation in Script

alexpetersen
New Contributor

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

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

Community Browser