topic Re: Cumulative in Pivot Table. in QlikView https://community.qlik.com/t5/QlikView/Cumulative-in-Pivot-Table/m-p/494129#M184853 <HTML><HEAD></HEAD><BODY><P>Hi Neha,</P><P></P><P>Your accomulative expression should be like this</P><P>RangeSum(Above(Total Sum(Qty),0,RowNo()))</P><P></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Thu, 18 Jul 2013 07:12:57 GMT Sokkorn 2013-07-18T07:12:57Z Cumulative in Pivot Table. https://community.qlik.com/t5/QlikView/Cumulative-in-Pivot-Table/m-p/494128#M184852 <HTML><HEAD></HEAD><BODY><P>Hello Community,</P><P></P><P>Need your help for below problem.</P><P></P><P>I have attached qvw in that I want cumulative for particular Item Name.</P><P></P><P>At present i am getting data as follows</P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#ffffff"><TH bgcolor="#f5f5f5" nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Item Name</STRONG></SPAN><STRONG> </STRONG></TH><TH bgcolor="#f5f5f5" nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>DATE</STRONG></SPAN><STRONG> </STRONG></TH><TD bgcolor="#ffffff"><SPAN style="color: #363636;">sum(Qty)</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Cumulative</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff" rowspan="2"><SPAN style="color: #363636;">A</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">21/2/2013</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">15</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">15</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1/2/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">75</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">90</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff" rowspan="3"><SPAN style="color: #363636;">B</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1/2/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">42</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">132</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">4/2/2013</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">45</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">177</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">6/4/2013</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">41</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">218</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff" rowspan="2"><SPAN style="color: #363636;">C</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1/2/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">70</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">288</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1/12/2013</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">20</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">308</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff" rowspan="2"><SPAN style="color: #363636;">D</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1/2/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">21</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">329</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">9/5/2013</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">31</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">360</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff" rowspan="2"><SPAN style="color: #363636;">E</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1/2/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">34</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">394</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">10/12/2013</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">34</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">428</SPAN></TD></TR></TBODY></TABLE><P></P><P> i want data as-</P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#ffffff"><TH bgcolor="#f5f5f5" nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Item Name</STRONG></SPAN><STRONG> </STRONG></TH><TH bgcolor="#f5f5f5" nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>DATE</STRONG></SPAN><STRONG> </STRONG></TH><TD bgcolor="#ffffff"><SPAN style="color: #363636;">sum(Qty)</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Cumulative</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff" rowspan="2"><SPAN style="color: #363636;">A</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">21/2/2013</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">15</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">15</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1/2/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">75</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">90</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff" rowspan="3"><SPAN style="color: #363636;">B</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1/2/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">42</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">42</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">4/2/2013</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">45</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">87</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">6/4/2013</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">41</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">128</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff" rowspan="2"><SPAN style="color: #363636;">C</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1/2/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">70</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">70</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1/12/2013</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">20</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">90</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff" rowspan="2"><SPAN style="color: #363636;">D</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1/2/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">21</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">21</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">9/5/2013</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">31</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">52</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff" rowspan="2"><SPAN style="color: #363636;">E</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1/2/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">34</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">34</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">10/12/2013</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">34</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">68</SPAN></TD></TR></TBODY></TABLE><P></P><P></P><P>Please help me with the problem.</P><P></P><P>Thanks.</P><P></P><P>-Neha</P></BODY></HTML> Thu, 18 Jul 2013 07:10:13 GMT https://community.qlik.com/t5/QlikView/Cumulative-in-Pivot-Table/m-p/494128#M184852 neha_shirsath 2013-07-18T07:10:13Z Re: Cumulative in Pivot Table. https://community.qlik.com/t5/QlikView/Cumulative-in-Pivot-Table/m-p/494129#M184853 <HTML><HEAD></HEAD><BODY><P>Hi Neha,</P><P></P><P>Your accomulative expression should be like this</P><P>RangeSum(Above(Total Sum(Qty),0,RowNo()))</P><P></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Thu, 18 Jul 2013 07:12:57 GMT https://community.qlik.com/t5/QlikView/Cumulative-in-Pivot-Table/m-p/494129#M184853 Sokkorn 2013-07-18T07:12:57Z Re: Cumulative in Pivot Table. https://community.qlik.com/t5/QlikView/Cumulative-in-Pivot-Table/m-p/494130#M184854 <HTML><HEAD></HEAD><BODY><P>Hi Sokkorn,</P><P></P><P>Thank you so much it's work.</P><P></P><P>-Neha</P></BODY></HTML> Thu, 18 Jul 2013 07:15:18 GMT https://community.qlik.com/t5/QlikView/Cumulative-in-Pivot-Table/m-p/494130#M184854 neha_shirsath 2013-07-18T07:15:18Z