https://community.qlik.com/t5/QlikView/accumulated-sum/m-p/1531686#M457260 <P>AsOf Calendar table is usually very helpful for accumulation. Please refer following link</P><P><A href="https://community.qlik.com/t5/QlikView-Documents/Calculating-rolling-n-period-totals-averages-or-other/ta-p/1483033" target="_blank">https://community.qlik.com/t5/QlikView-Documents/Calculating-rolling-n-period-totals-averages-or-other/ta-p/1483033</A></P> Thu, 17 Jan 2019 16:15:33 GMT vvira1316 2019-01-17T16:15:33Z https://community.qlik.com/t5/QlikView/accumulated-sum/m-p/1531678#M457259 <P>Hi all,</P><P>in my model i have an expression which is working well in a straight table ,</P><P>within the straight table, when user select Apr-18 in the calendar the <SPAN>expression&nbsp;</SPAN>will retrieve the sum of all Sales below the max date (04/30/2018).</P><P>i want to&nbsp;use this kind of expression with month dimension (chart or a table) , but it is not working as i need the accumulated sum per each month.</P><P>sum({$&lt;ValueDate=,YearMonth=, Year=,Month=,Group={50,51},Date= {"&lt;=$(vPossibleDates)"} &gt; } Sales)</P><P><SPAN>vPossibleDates&nbsp;</SPAN>= date(max(ValueDate))</P><P>&nbsp;</P><P>any ideas ?</P><P>advanced thanks&nbsp;</P> Sat, 16 Nov 2024 04:43:42 GMT https://community.qlik.com/t5/QlikView/accumulated-sum/m-p/1531678#M457259 ilanbaruch 2024-11-16T04:43:42Z https://community.qlik.com/t5/QlikView/accumulated-sum/m-p/1531686#M457260 <P>AsOf Calendar table is usually very helpful for accumulation. Please refer following link</P><P><A href="https://community.qlik.com/t5/QlikView-Documents/Calculating-rolling-n-period-totals-averages-or-other/ta-p/1483033" target="_blank">https://community.qlik.com/t5/QlikView-Documents/Calculating-rolling-n-period-totals-averages-or-other/ta-p/1483033</A></P> Thu, 17 Jan 2019 16:15:33 GMT https://community.qlik.com/t5/QlikView/accumulated-sum/m-p/1531686#M457260 vvira1316 2019-01-17T16:15:33Z