topic Re: Full Accumulation in QlikSense in App Development https://community.qlik.com/t5/App-Development/Full-Accumulation-in-QlikSense/m-p/1336257#M29319 <HTML><HEAD></HEAD><BODY><P>Do you have two dimensions in your chart? May be this</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>=RangeSum(Above(TOTAL Sum({&lt;[Opps.IsWon] = {'1'}&gt;}[Opps.ARR_equivalent__c]), 0, RowNo(TOTAL)))</STRONG></SPAN></P></BODY></HTML> Wed, 21 Jun 2017 17:11:33 GMT sunny_talwar 2017-06-21T17:11:33Z Full Accumulation in QlikSense https://community.qlik.com/t5/App-Development/Full-Accumulation-in-QlikSense/m-p/1336256#M29318 <HTML><HEAD></HEAD><BODY><P>Goal is to sum subscription dollars over time to see how individual companies are growing within our ecosystem over time.</P><P></P><P>I am using QlikSense. I know there is not a Full Accumulation button in QlikSense so I have been using the following expression.</P><P></P><P>= rangesum(above(Sum({&lt;[Opps.IsWon] = {'1'}&gt;}[Opps.ARR_equivalent__c]),0,rowno()))</P><P></P><P>However it is not working as expected. If you see the graph below it is just summing the subscription amounts per subscription start date (x axis) ... Any help is appreciated!!!</P><P></P><P><IMG alt="QLIK06212017.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/167681_QLIK06212017.PNG" style="height: 207px; width: 620px;" /></P></BODY></HTML> Wed, 21 Jun 2017 16:42:56 GMT https://community.qlik.com/t5/App-Development/Full-Accumulation-in-QlikSense/m-p/1336256#M29318 Anonymous 2017-06-21T16:42:56Z Re: Full Accumulation in QlikSense https://community.qlik.com/t5/App-Development/Full-Accumulation-in-QlikSense/m-p/1336257#M29319 <HTML><HEAD></HEAD><BODY><P>Do you have two dimensions in your chart? May be this</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>=RangeSum(Above(TOTAL Sum({&lt;[Opps.IsWon] = {'1'}&gt;}[Opps.ARR_equivalent__c]), 0, RowNo(TOTAL)))</STRONG></SPAN></P></BODY></HTML> Wed, 21 Jun 2017 17:11:33 GMT https://community.qlik.com/t5/App-Development/Full-Accumulation-in-QlikSense/m-p/1336257#M29319 sunny_talwar 2017-06-21T17:11:33Z Re: Full Accumulation in QlikSense https://community.qlik.com/t5/App-Development/Full-Accumulation-in-QlikSense/m-p/1336258#M29320 <HTML><HEAD></HEAD><BODY><P>Yes I do, 1 dimension is SUBSCRIPTION START DATE on X axis, 2nd dimension is ACCOUNT NAME ...</P><P></P><P>This worked. Thank you!</P></BODY></HTML> Wed, 21 Jun 2017 17:34:52 GMT https://community.qlik.com/t5/App-Development/Full-Accumulation-in-QlikSense/m-p/1336258#M29320 Anonymous 2017-06-21T17:34:52Z