topic Re: Cumulative Values.. in QlikView https://community.qlik.com/t5/QlikView/Cumulative-Values/m-p/486397#M181721 <HTML><HEAD></HEAD><BODY><P>Hi, check the example</P></BODY></HTML> Thu, 05 Sep 2013 10:03:39 GMT 2013-09-05T10:03:39Z Cumulative Values.. https://community.qlik.com/t5/QlikView/Cumulative-Values/m-p/486393#M181717 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Need help in Cumulative Calculation..</P><P></P><P>I Have a table like...</P><P></P><P></P><P><SPAN style="color: #0000ff;">Names&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Values</SPAN></P><P><SPAN style="color: #0000ff;">A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</SPAN></P><P><SPAN style="color: #0000ff;">B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</SPAN></P><P><SPAN style="color: #0000ff;">C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30</SPAN></P><P></P><P>now I want a new Colume with Cumlative Values</P><P></P><P>Like..</P><P></P><P><SPAN style="color: #0000ff;">Cumulative_Values</SPAN></P><P><SPAN style="color: #0000ff;">10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =10</SPAN></P><P><SPAN style="color: #0000ff;">(10+20)/2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =15</SPAN></P><P><SPAN style="color: #0000ff;">(10+20+30)/3&nbsp;&nbsp;&nbsp;&nbsp; =20</SPAN></P><P></P><P>Thanks in Advance...</P></BODY></HTML> Thu, 05 Sep 2013 09:46:40 GMT https://community.qlik.com/t5/QlikView/Cumulative-Values/m-p/486393#M181717 sravan_v007 2013-09-05T09:46:40Z Re: Cumulative Values.. https://community.qlik.com/t5/QlikView/Cumulative-Values/m-p/486394#M181718 <HTML><HEAD></HEAD><BODY><P>Maybe like</P><P></P><P>=rangesum( above( sum( Value),0,rowno() )) / rowno()</P></BODY></HTML> Thu, 05 Sep 2013 09:53:40 GMT https://community.qlik.com/t5/QlikView/Cumulative-Values/m-p/486394#M181718 swuehl 2013-09-05T09:53:40Z Re: Cumulative Values.. https://community.qlik.com/t5/QlikView/Cumulative-Values/m-p/486395#M181719 <HTML><HEAD></HEAD><BODY><P>PFA</P></BODY></HTML> Thu, 05 Sep 2013 09:57:36 GMT https://community.qlik.com/t5/QlikView/Cumulative-Values/m-p/486395#M181719 tresB 2013-09-05T09:57:36Z Re: Cumulative Values.. https://community.qlik.com/t5/QlikView/Cumulative-Values/m-p/486396#M181720 <HTML><HEAD></HEAD><BODY><P>try this code</P><P><STRONG>RangeSum(Above(sum( Values),0,RowNo()))/RowNo()</STRONG></P><P></P><P>then output like this</P><TABLE border="0" cellpadding="0" cellspacing="0" width="294"><TBODY><TR><TD class="xl63" height="17" width="98">Names</TD><TD class="xl64" width="98">Values</TD><TD class="xl64" style="border-left: none;" width="98">Accumulate</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">A</TD><TD class="xl64" style="border-top: none; border-left: none;">10</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">10</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">B</TD><TD class="xl64" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">15</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">C</TD><TD class="xl64" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">20</TD></TR></TBODY></TABLE></BODY></HTML> Thu, 05 Sep 2013 10:01:33 GMT https://community.qlik.com/t5/QlikView/Cumulative-Values/m-p/486396#M181720 2013-09-05T10:01:33Z Re: Cumulative Values.. https://community.qlik.com/t5/QlikView/Cumulative-Values/m-p/486397#M181721 <HTML><HEAD></HEAD><BODY><P>Hi, check the example</P></BODY></HTML> Thu, 05 Sep 2013 10:03:39 GMT https://community.qlik.com/t5/QlikView/Cumulative-Values/m-p/486397#M181721 2013-09-05T10:03:39Z