topic Re: Replicate the Full Accumulation QV function with Data Analysis in QlikView https://community.qlik.com/t5/QlikView/Replicate-the-Full-Accumulation-QV-function-with-Data-Analysis/m-p/954706#M328189 <HTML><HEAD></HEAD><BODY><P>You can do full accumulation using this general formula:</P><P></P><P><STRONG>RangeSum(Above(YourExpression, 0, RowNo()))</STRONG></P></BODY></HTML> Tue, 15 Sep 2015 14:46:13 GMT sunny_talwar 2015-09-15T14:46:13Z Replicate the Full Accumulation QV function with Data Analysis https://community.qlik.com/t5/QlikView/Replicate-the-Full-Accumulation-QV-function-with-Data-Analysis/m-p/954704#M328187 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I would like to use the result produced by the full accumulation QV functionality as part of another formula (please see attachment for clarification). I have tried to access the monthly cell values with the COLUMN() function but it does not return the accumulated value. Is there anyway to accomplish this using set analysis or Qlikview functions?</P><P></P><P>Thanks in advance</P></BODY></HTML> Tue, 15 Sep 2015 14:27:10 GMT https://community.qlik.com/t5/QlikView/Replicate-the-Full-Accumulation-QV-function-with-Data-Analysis/m-p/954704#M328187 2015-09-15T14:27:10Z Re: Replicate the Full Accumulation QV function with Data Analysis https://community.qlik.com/t5/QlikView/Replicate-the-Full-Accumulation-QV-function-with-Data-Analysis/m-p/954705#M328188 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>May be try this..</P><P></P><P>=Rangesum(Above(TOTAL sum(YourExpression),0,rowno(TOTAL)))</P><P></P><P><SPAN style="text-decoration: underline;">Accumulation</SPAN> : No Accumulation</P></BODY></HTML> Tue, 15 Sep 2015 14:45:43 GMT https://community.qlik.com/t5/QlikView/Replicate-the-Full-Accumulation-QV-function-with-Data-Analysis/m-p/954705#M328188 settu_periasamy 2015-09-15T14:45:43Z Re: Replicate the Full Accumulation QV function with Data Analysis https://community.qlik.com/t5/QlikView/Replicate-the-Full-Accumulation-QV-function-with-Data-Analysis/m-p/954706#M328189 <HTML><HEAD></HEAD><BODY><P>You can do full accumulation using this general formula:</P><P></P><P><STRONG>RangeSum(Above(YourExpression, 0, RowNo()))</STRONG></P></BODY></HTML> Tue, 15 Sep 2015 14:46:13 GMT https://community.qlik.com/t5/QlikView/Replicate-the-Full-Accumulation-QV-function-with-Data-Analysis/m-p/954706#M328189 sunny_talwar 2015-09-15T14:46:13Z Re: Replicate the Full Accumulation QV function with Data Analysis https://community.qlik.com/t5/QlikView/Replicate-the-Full-Accumulation-QV-function-with-Data-Analysis/m-p/954707#M328190 <HTML><HEAD></HEAD><BODY><P>Thank you, this is exactly what I was after <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 15 Sep 2015 16:23:39 GMT https://community.qlik.com/t5/QlikView/Replicate-the-Full-Accumulation-QV-function-with-Data-Analysis/m-p/954707#M328190 2015-09-15T16:23:39Z