topic Re: Average line in Line chart in QlikView https://community.qlik.com/t5/QlikView/Average-line-in-Line-chart/m-p/1054892#M353710 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>Avg(TOTAL Aggr(</STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Sum({SPP&lt;MonthEndDate={"&gt;=$(=vlast12Months)"}&gt;}Sales), Year-Month, City))</STRONG></SPAN></P></BODY></HTML> Wed, 23 Mar 2016 11:41:03 GMT sunny_talwar 2016-03-23T11:41:03Z Average line in Line chart https://community.qlik.com/t5/QlikView/Average-line-in-Line-chart/m-p/1054891#M353709 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have line chart which shows multiple trend line as per the second dimension. In addition to that I need a one more line which should show average sales.</P><P></P><P>Dimensions used:</P><P>1. Year-Month</P><P>2. City</P><P></P><P>Example used:</P><P>SUM({SPP&lt;MonthEndDate={"&gt;=$(=vlast12Months)"}&gt;}Sales)</P><P></P><P>Advance thanks!!</P></BODY></HTML> Wed, 23 Mar 2016 10:00:46 GMT https://community.qlik.com/t5/QlikView/Average-line-in-Line-chart/m-p/1054891#M353709 2016-03-23T10:00:46Z Re: Average line in Line chart https://community.qlik.com/t5/QlikView/Average-line-in-Line-chart/m-p/1054892#M353710 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>Avg(TOTAL Aggr(</STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Sum({SPP&lt;MonthEndDate={"&gt;=$(=vlast12Months)"}&gt;}Sales), Year-Month, City))</STRONG></SPAN></P></BODY></HTML> Wed, 23 Mar 2016 11:41:03 GMT https://community.qlik.com/t5/QlikView/Average-line-in-Line-chart/m-p/1054892#M353710 sunny_talwar 2016-03-23T11:41:03Z