topic Store end amount of accumulation graph as a variable. in QlikView https://community.qlik.com/t5/QlikView/Store-end-amount-of-accumulation-graph-as-a-variable/m-p/348195#M575776 <HTML><HEAD></HEAD><BODY><P>Assuming your chart dimension is something like Month, and your chart expression is Sum(Sales), try:</P><P></P><P>=Max(Aggr(RangeSum(Above(Sum(Sales),0,RowNo())),Month))</P><P></P><P>Hope this helps,</P><P></P><P>Jason</P></BODY></HTML> Fri, 11 May 2012 21:10:33 GMT Jason_Michaelides 2012-05-11T21:10:33Z Store end amount of accumulation graph as a variable. https://community.qlik.com/t5/QlikView/Store-end-amount-of-accumulation-graph-as-a-variable/m-p/348194#M575775 <HTML><HEAD></HEAD><BODY><P> Hi community,&nbsp; I have an line graph with full accumulation that has an ending value.&nbsp; I put the same set analysis in a variable and for some reason it's slightly off.&nbsp; All I want is the accumulation value with current selections stored as a variable.&nbsp; Is there anayway to do this?</P></BODY></HTML> Fri, 11 May 2012 15:35:05 GMT https://community.qlik.com/t5/QlikView/Store-end-amount-of-accumulation-graph-as-a-variable/m-p/348194#M575775 2012-05-11T15:35:05Z Store end amount of accumulation graph as a variable. https://community.qlik.com/t5/QlikView/Store-end-amount-of-accumulation-graph-as-a-variable/m-p/348195#M575776 <HTML><HEAD></HEAD><BODY><P>Assuming your chart dimension is something like Month, and your chart expression is Sum(Sales), try:</P><P></P><P>=Max(Aggr(RangeSum(Above(Sum(Sales),0,RowNo())),Month))</P><P></P><P>Hope this helps,</P><P></P><P>Jason</P></BODY></HTML> Fri, 11 May 2012 21:10:33 GMT https://community.qlik.com/t5/QlikView/Store-end-amount-of-accumulation-graph-as-a-variable/m-p/348195#M575776 Jason_Michaelides 2012-05-11T21:10:33Z