topic expression accumulated by date in QlikView https://community.qlik.com/t5/QlikView/expression-accumulated-by-date/m-p/361473#M134285 <HTML><HEAD></HEAD><BODY><P>If checking the "Full Accumulation" box isn't sufficient, then try:</P><P></P><P>RangeSum(Above(Sum(Sales),0,RowNo())) where Month is your chart dimension.</P><P></P><P>Hope this helps,</P><P></P><P>Jason</P></BODY></HTML> Mon, 21 May 2012 14:31:32 GMT Jason_Michaelides 2012-05-21T14:31:32Z expression accumulated by date https://community.qlik.com/t5/QlikView/expression-accumulated-by-date/m-p/361472#M134284 <HTML><HEAD></HEAD><BODY><DIV dir="ltr" style="zoom: 1;"><SPAN id="result_box" lang="en"><SPAN class="hps">Hello,</SPAN><BR /> <SPAN class="hps">I need</SPAN> <SPAN class="hps">an</SPAN> <SPAN class="hps">expression for</SPAN> <SPAN class="hps">a</SPAN> <SPAN class="hps">bar</SPAN> <SPAN class="hps">chart</SPAN> <SPAN class="hps">that accumulates</SPAN> <SPAN class="hps">values</SPAN> <SPAN class="hps">​​from</SPAN> <SPAN class="hps">January 2012</SPAN> <SPAN class="hps">eg if</SPAN> <SPAN class="hps">dimension</SPAN> <SPAN class="hps">I have</SPAN> <SPAN class="hps">in my</SPAN> <SPAN class="hps">January</SPAN>, <SPAN class="hps">February</SPAN>, <SPAN class="hps">March</SPAN> <SPAN class="hps">and</SPAN> <SPAN class="hps">April</SPAN>, <SPAN class="hps">I</SPAN> <SPAN class="hps">accumulated</SPAN> <SPAN class="hps">returns</SPAN> <SPAN class="hps">in January</SPAN> <SPAN class="hps">+</SPAN> <SPAN class="hps">February</SPAN> <SPAN class="hps">+</SPAN> <SPAN class="hps">January</SPAN> <SPAN class="hps">+</SPAN> <SPAN class="hps">February</SPAN> <SPAN class="hps">March</SPAN>, April <SPAN class="hps">+</SPAN> <SPAN class="hps">February</SPAN> <SPAN class="hps">+</SPAN> <SPAN class="hps">March</SPAN> <SPAN class="hps">+</SPAN> <SPAN class="hps">April</SPAN>.</SPAN><P></P></DIV><P id="gt-res-tools"></P><DIV id="gt-src-tools-l"><A id="gt-undo" style="display: none;">Desfazer edições</A><P></P><P id="gt-res-tools-r"></P><DIV class="trans-listen-button goog-toolbar-button" id="gt-res-listen"><SPAN class="jfk-button-img"> </SPAN><P></P><P class="trans-roman-button goog-toolbar-button" id="gt-res-roman" style="display: none;"><SPAN class="jfk-button-img"> </SPAN></P><P id="gt-res-rate"></P><DIV class="goog-inline-block goog-toolbar-menu-button"><DIV class="goog-inline-block goog-toolbar-menu-button-outer-box"><DIV class="goog-inline-block goog-toolbar-menu-button-inner-box"><DIV class="goog-inline-block goog-toolbar-menu-button-caption"><SPAN class="goog-flat-menu-button-img gt-rate-icon jfk-button-img"> </SPAN><P></P></DIV></DIV></DIV></DIV></DIV></DIV></BODY></HTML> Mon, 21 May 2012 14:24:29 GMT https://community.qlik.com/t5/QlikView/expression-accumulated-by-date/m-p/361472#M134284 rogeriobarbosa 2012-05-21T14:24:29Z expression accumulated by date https://community.qlik.com/t5/QlikView/expression-accumulated-by-date/m-p/361473#M134285 <HTML><HEAD></HEAD><BODY><P>If checking the "Full Accumulation" box isn't sufficient, then try:</P><P></P><P>RangeSum(Above(Sum(Sales),0,RowNo())) where Month is your chart dimension.</P><P></P><P>Hope this helps,</P><P></P><P>Jason</P></BODY></HTML> Mon, 21 May 2012 14:31:32 GMT https://community.qlik.com/t5/QlikView/expression-accumulated-by-date/m-p/361473#M134285 Jason_Michaelides 2012-05-21T14:31:32Z