topic Re: AVG Trendline Issue in QlikView https://community.qlik.com/t5/QlikView/AVG-Trendline-Issue/m-p/909359#M315801 <HTML><HEAD></HEAD><BODY><P>Thanks for the quick response. It doesn't seem to work. </P></BODY></HTML> Tue, 04 Aug 2015 08:52:00 GMT 2015-08-04T08:52:00Z AVG Trendline Issue https://community.qlik.com/t5/QlikView/AVG-Trendline-Issue/m-p/909357#M315799 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>I am not able to draw a AVERAGE Trendline for the below chart. The problem is the chart is showing 2 Average Trendline for different products. I only want to show 1 Average Trendline for the total products. Anyone out there able to advise ?<IMG alt="Trendline.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/94908_Trendline.jpg" style="width: 620px; height: 371px;" /> </P></BODY></HTML> Tue, 04 Aug 2015 08:23:05 GMT https://community.qlik.com/t5/QlikView/AVG-Trendline-Issue/m-p/909357#M315799 2015-08-04T08:23:05Z Re: AVG Trendline Issue https://community.qlik.com/t5/QlikView/AVG-Trendline-Issue/m-p/909358#M315800 <HTML><HEAD></HEAD><BODY><P>Add one reference line on the Presentation tab using this expression: <STRONG>=avg(aggr( <EM>avg(Amount)</EM>, Trade_Month_Year))</STRONG>. Replace avg(Amount) with the expression you use for the bar segments.</P></BODY></HTML> Tue, 04 Aug 2015 08:30:08 GMT https://community.qlik.com/t5/QlikView/AVG-Trendline-Issue/m-p/909358#M315800 Gysbert_Wassenaar 2015-08-04T08:30:08Z Re: AVG Trendline Issue https://community.qlik.com/t5/QlikView/AVG-Trendline-Issue/m-p/909359#M315801 <HTML><HEAD></HEAD><BODY><P>Thanks for the quick response. It doesn't seem to work. </P></BODY></HTML> Tue, 04 Aug 2015 08:52:00 GMT https://community.qlik.com/t5/QlikView/AVG-Trendline-Issue/m-p/909359#M315801 2015-08-04T08:52:00Z Re: AVG Trendline Issue https://community.qlik.com/t5/QlikView/AVG-Trendline-Issue/m-p/909360#M315802 <HTML><HEAD></HEAD><BODY><P>Please post a qlikview document that demonstrates the problem.</P></BODY></HTML> Tue, 04 Aug 2015 08:57:26 GMT https://community.qlik.com/t5/QlikView/AVG-Trendline-Issue/m-p/909360#M315802 Gysbert_Wassenaar 2015-08-04T08:57:26Z Re: AVG Trendline Issue https://community.qlik.com/t5/QlikView/AVG-Trendline-Issue/m-p/909361#M315803 <HTML><HEAD></HEAD><BODY><P>Hi Gysbert,</P><P></P><P>The Average Trendline comes out nicely, after I did some changes to the Expression. Your suggestion is good and I only need to make some changed. THANKS A LOT!!</P></BODY></HTML> Tue, 04 Aug 2015 09:48:52 GMT https://community.qlik.com/t5/QlikView/AVG-Trendline-Issue/m-p/909361#M315803 2015-08-04T09:48:52Z