topic Expression for cummulative sum in QlikView https://community.qlik.com/t5/QlikView/Expression-for-cummulative-sum/m-p/850886#M993176 <HTML><HEAD></HEAD><BODY><P>How to do the following expression :</P><P></P><P><IMG alt="snap.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/92516_snap.PNG" style="height: auto;" /></P><P></P><P>Trading Day&nbsp; :&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; New</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4314965</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8629930</P><P>...</P><P>...</P><P>...</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 19&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 81984344</P><P></P><P>and Total shoulbe also 81984344</P><P></P><P>I am using variables : </P><P></P><P>Column <SPAN style="font-size: 10pt; line-height: 1.5em;">Budget : vBudget : </SPAN><SPAN style="font-size: 13.3333330154419px;">sum({$&lt;TranType = {'Budget_$(vAmountType)'},CurrentPer = {1},Fiscal_Year = {$(=max(Fiscal_Year))}&gt;} Amount)</SPAN></P><P></P><P></P><P><SPAN style="font-size: 13.3333330154419px;">Column </SPAN><SPAN style="font-size: 10pt;">New : vNew :&nbsp; </SPAN>sum({$&lt;TranType = {'Budget_$(vAmountType)'},CurrentPer = {1},Fiscal_Year = {$(=max(Fiscal_Year))}&gt;} Amount)/no_trading_days </P><P></P><P></P><P>Unable to upload sample model.</P></BODY></HTML> Fri, 10 Jul 2015 13:58:38 GMT suvechha_b 2015-07-10T13:58:38Z Expression for cummulative sum https://community.qlik.com/t5/QlikView/Expression-for-cummulative-sum/m-p/850886#M993176 <HTML><HEAD></HEAD><BODY><P>How to do the following expression :</P><P></P><P><IMG alt="snap.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/92516_snap.PNG" style="height: auto;" /></P><P></P><P>Trading Day&nbsp; :&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; New</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4314965</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8629930</P><P>...</P><P>...</P><P>...</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 19&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 81984344</P><P></P><P>and Total shoulbe also 81984344</P><P></P><P>I am using variables : </P><P></P><P>Column <SPAN style="font-size: 10pt; line-height: 1.5em;">Budget : vBudget : </SPAN><SPAN style="font-size: 13.3333330154419px;">sum({$&lt;TranType = {'Budget_$(vAmountType)'},CurrentPer = {1},Fiscal_Year = {$(=max(Fiscal_Year))}&gt;} Amount)</SPAN></P><P></P><P></P><P><SPAN style="font-size: 13.3333330154419px;">Column </SPAN><SPAN style="font-size: 10pt;">New : vNew :&nbsp; </SPAN>sum({$&lt;TranType = {'Budget_$(vAmountType)'},CurrentPer = {1},Fiscal_Year = {$(=max(Fiscal_Year))}&gt;} Amount)/no_trading_days </P><P></P><P></P><P>Unable to upload sample model.</P></BODY></HTML> Fri, 10 Jul 2015 13:58:38 GMT https://community.qlik.com/t5/QlikView/Expression-for-cummulative-sum/m-p/850886#M993176 suvechha_b 2015-07-10T13:58:38Z Re: Expression for cummulative sum https://community.qlik.com/t5/QlikView/Expression-for-cummulative-sum/m-p/850887#M993177 <HTML><HEAD></HEAD><BODY><P>For Cumulative Total</P><P></P><P>RangeSum(Above(SUM(Sales),0,RowNo()))</P><P>or</P><P>RangeSum(Above(TOTAL SUM(Sales),0,RowNo(TOTAL)))</P><P></P><P>Replace SUM(Sales) with your Expression.</P></BODY></HTML> Fri, 10 Jul 2015 14:04:32 GMT https://community.qlik.com/t5/QlikView/Expression-for-cummulative-sum/m-p/850887#M993177 MK_QSL 2015-07-10T14:04:32Z