topic Re: Total avg in linechart in QlikView https://community.qlik.com/t5/QlikView/Total-avg-in-linechart/m-p/1053093#M933085 <HTML><HEAD></HEAD><BODY><P>add new Expression: <SPAN style="color: #0000ff; font-size: 8pt;">aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">avg</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Sales</SPAN><SPAN style="font-size: 8pt;">) / </SPAN><SPAN style="color: #800000; font-size: 8pt;">Quantity</SPAN><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #800000; font-size: 8pt;">Period</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P></BODY></HTML> Mon, 29 Feb 2016 16:11:44 GMT Anonymous 2016-02-29T16:11:44Z Total avg in linechart https://community.qlik.com/t5/QlikView/Total-avg-in-linechart/m-p/1053092#M933084 <HTML><HEAD></HEAD><BODY><P>I like to have an avg of Total(Sales) /&nbsp; quantity till the periode in my chart</P><P></P><P>Accumalate is not the solution</P><P></P><P>I include an example</P><P></P><P>Has someone a solution ?</P></BODY></HTML> Mon, 29 Feb 2016 16:08:44 GMT https://community.qlik.com/t5/QlikView/Total-avg-in-linechart/m-p/1053092#M933084 francisvandergr 2016-02-29T16:08:44Z Re: Total avg in linechart https://community.qlik.com/t5/QlikView/Total-avg-in-linechart/m-p/1053093#M933085 <HTML><HEAD></HEAD><BODY><P>add new Expression: <SPAN style="color: #0000ff; font-size: 8pt;">aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">avg</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Sales</SPAN><SPAN style="font-size: 8pt;">) / </SPAN><SPAN style="color: #800000; font-size: 8pt;">Quantity</SPAN><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #800000; font-size: 8pt;">Period</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P></BODY></HTML> Mon, 29 Feb 2016 16:11:44 GMT https://community.qlik.com/t5/QlikView/Total-avg-in-linechart/m-p/1053093#M933085 Anonymous 2016-02-29T16:11:44Z Re: Total avg in linechart https://community.qlik.com/t5/QlikView/Total-avg-in-linechart/m-p/1053094#M933086 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>RangeSum(Above(Sum(Sales), 0, RowNo()))/RangeSum(Above(Sum(Quantity), 0, RowNo()))</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG __jive_id="116321" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/116321_Capture.PNG" style="height: auto;" /></STRONG></P><P><STRONG>UPDATE: </STRONG>Make sure you set Accumulation back to No Accumulation<STRONG><BR /></STRONG></P></BODY></HTML> Mon, 29 Feb 2016 16:14:34 GMT https://community.qlik.com/t5/QlikView/Total-avg-in-linechart/m-p/1053094#M933086 sunny_talwar 2016-02-29T16:14:34Z Re: Total avg in linechart https://community.qlik.com/t5/QlikView/Total-avg-in-linechart/m-p/1053095#M933087 <HTML><HEAD></HEAD><BODY><P>May be like this..</P><P></P><P>=Rangesum(above(total Sum(Sales),0,Period))/</P><P>Rangesum(above(total Sum(Quantity),0,Period))</P></BODY></HTML> Mon, 29 Feb 2016 16:23:13 GMT https://community.qlik.com/t5/QlikView/Total-avg-in-linechart/m-p/1053095#M933087 settu_periasamy 2016-02-29T16:23:13Z