topic Re: How to calculate accumulation based on another calculated value and not the governing dimension in App Development https://community.qlik.com/t5/App-Development/How-to-calculate-accumulation-based-on-another-calculated-value/m-p/110753#M7597 <HTML><HEAD></HEAD><BODY><P>May be try this:</P><P><A href="https://community.qlik.com/thread/24988">Accumulation in Script</A></P></BODY></HTML> Wed, 04 Jul 2018 16:32:06 GMT BalaBhaskar_Qlik 2018-07-04T16:32:06Z How to calculate accumulation based on another calculated value and not the governing dimension https://community.qlik.com/t5/App-Development/How-to-calculate-accumulation-based-on-another-calculated-value/m-p/110752#M7596 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I'm familiar with using RangeSum to calculate the accumulated values in a table (see expression below). </P><P></P><P>My problem is how do I calculate accumulation based on another calculated value/column instead of the governing dimension?</P><P></P><P>rangesum( above( sum([Expression1]),0,rowno()))</P><P></P><P>I hope you guys can help! Thanks!</P><P></P><P>Br, Alexander</P></BODY></HTML> Wed, 04 Jul 2018 14:46:18 GMT https://community.qlik.com/t5/App-Development/How-to-calculate-accumulation-based-on-another-calculated-value/m-p/110752#M7596 Anonymous 2018-07-04T14:46:18Z Re: How to calculate accumulation based on another calculated value and not the governing dimension https://community.qlik.com/t5/App-Development/How-to-calculate-accumulation-based-on-another-calculated-value/m-p/110753#M7597 <HTML><HEAD></HEAD><BODY><P>May be try this:</P><P><A href="https://community.qlik.com/thread/24988">Accumulation in Script</A></P></BODY></HTML> Wed, 04 Jul 2018 16:32:06 GMT https://community.qlik.com/t5/App-Development/How-to-calculate-accumulation-based-on-another-calculated-value/m-p/110753#M7597 BalaBhaskar_Qlik 2018-07-04T16:32:06Z Re: How to calculate accumulation based on another calculated value and not the governing dimension https://community.qlik.com/t5/App-Development/How-to-calculate-accumulation-based-on-another-calculated-value/m-p/110754#M7598 <HTML><HEAD></HEAD><BODY><P>I actually found the perfect solution in another thread after I posted this.</P><P></P><P>See here: <A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/12/09/pareto-analysis">https://community.qlik.com/blogs/qlikviewdesignblog/2013/12/09/pareto-analysis</A></P></BODY></HTML> Fri, 06 Jul 2018 11:28:20 GMT https://community.qlik.com/t5/App-Development/How-to-calculate-accumulation-based-on-another-calculated-value/m-p/110754#M7598 Anonymous 2018-07-06T11:28:20Z