topic Re: Cumulative Bar Chart Multiplying Results? in QlikView https://community.qlik.com/t5/QlikView/Cumulative-Bar-Chart-Multiplying-Results/m-p/470332#M563358 <HTML><HEAD></HEAD><BODY><P>Read this blog.. Hope it will help you to solve.</P><P></P><P><A _jive_internal="true" class="loading" href="https://community.qlik.com/blogs/qlikviewdesignblog/2012/10/12/accumulative-sums" title="http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/12/accumulative-sums">http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/12/accumulative-sums</A></P></BODY></HTML> Tue, 26 Feb 2013 09:47:04 GMT 2013-02-26T09:47:04Z Cumulative Bar Chart Multiplying Results? https://community.qlik.com/t5/QlikView/Cumulative-Bar-Chart-Multiplying-Results/m-p/470331#M563357 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I am trying to create a cumulative bar chart using the expression:</P><P><SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; </SPAN></P><P><SPAN style=": ; color: #0000ff; font-size: 8pt;"></SPAN></P><P>Rangesum</P><P></P><P><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">above</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">TOTAL</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Product_id</SPAN><SPAN style="font-size: 8pt;">), 0, </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">rowno</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">total</SPAN><SPAN style="font-size: 8pt;">))) </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">It works fine when just selecting one product, however when I select more than one product, it multiplies the result in the chart. Please see the attached picture of product A &amp; D. In reality, product A has only sold 27 for this period, it is D that has sold 1058. </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">I would expect then for the cumulative total in 2012 to be 1085. Instead it appears to be ~2,200. </SPAN></P><P><SPAN style="font-size: 10pt;"> </SPAN></P><P><SPAN style="font-size: 10pt;">I know the problem is in the chart - I have attached the straight table behind this chart and it accumulates just fine. </SPAN></P><P></P><P>Also an additional point - I have this chart set to 'no accumulation' since this is what the expression does and when I do set it to 'full accumulation' the results are multiplied further. </P><P></P><P>Any help would be appreciated! I can't see where this has gone wrong...</P><P></P><P>Thanks! </P><P></P><P>M</P></BODY></HTML> Tue, 26 Feb 2013 09:34:43 GMT https://community.qlik.com/t5/QlikView/Cumulative-Bar-Chart-Multiplying-Results/m-p/470331#M563357 2013-02-26T09:34:43Z Re: Cumulative Bar Chart Multiplying Results? https://community.qlik.com/t5/QlikView/Cumulative-Bar-Chart-Multiplying-Results/m-p/470332#M563358 <HTML><HEAD></HEAD><BODY><P>Read this blog.. Hope it will help you to solve.</P><P></P><P><A _jive_internal="true" class="loading" href="https://community.qlik.com/blogs/qlikviewdesignblog/2012/10/12/accumulative-sums" title="http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/12/accumulative-sums">http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/12/accumulative-sums</A></P></BODY></HTML> Tue, 26 Feb 2013 09:47:04 GMT https://community.qlik.com/t5/QlikView/Cumulative-Bar-Chart-Multiplying-Results/m-p/470332#M563358 2013-02-26T09:47:04Z