topic Re: Adding Average Lines to Trellis in QlikView https://community.qlik.com/t5/QlikView/Adding-Average-Lines-to-Trellis/m-p/1331389#M411261 <HTML><HEAD></HEAD><BODY><P>or use a separate calendar....</P></BODY></HTML> Tue, 01 Aug 2017 20:06:00 GMT Anonymous 2017-08-01T20:06:00Z Adding Average Lines to Trellis https://community.qlik.com/t5/QlikView/Adding-Average-Lines-to-Trellis/m-p/1331383#M411255 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P></P><P>I'm creating a trellis line chart which a tracks a value year over month. I'd like to add a line indicating the average value per year to each section of the trellis chart. I've tried following this solution:</P><P></P><P><A href="https://community.qlik.com/thread/64174">Reference lines for each section of the trellis chart</A></P><P></P><P>I've attached a small application as an example. I can calculate the correct yearly average, however I'm not able to extend that value to all months in the given year. I would like my chart to look like the below image.</P><P></P><P>Thanks!</P><P></P><P>Michael</P><P></P><P><IMG alt="graph_sample.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/172101_graph_sample.png" style="height: 150px; width: 620px;" /></P></BODY></HTML> Tue, 01 Aug 2017 18:40:49 GMT https://community.qlik.com/t5/QlikView/Adding-Average-Lines-to-Trellis/m-p/1331383#M411255 Anonymous 2017-08-01T18:40:49Z Re: Adding Average Lines to Trellis https://community.qlik.com/t5/QlikView/Adding-Average-Lines-to-Trellis/m-p/1331384#M411256 <HTML><HEAD></HEAD><BODY><P>do you want to achieve 12 separate&nbsp; data points for 2014?</P></BODY></HTML> Tue, 01 Aug 2017 18:48:15 GMT https://community.qlik.com/t5/QlikView/Adding-Average-Lines-to-Trellis/m-p/1331384#M411256 Anonymous 2017-08-01T18:48:15Z Re: Adding Average Lines to Trellis https://community.qlik.com/t5/QlikView/Adding-Average-Lines-to-Trellis/m-p/1331385#M411257 <HTML><HEAD></HEAD><BODY><P>Yes, I believe that's what I want. As long as the average line extends across all months for each year.</P></BODY></HTML> Tue, 01 Aug 2017 18:55:37 GMT https://community.qlik.com/t5/QlikView/Adding-Average-Lines-to-Trellis/m-p/1331385#M411257 Anonymous 2017-08-01T18:55:37Z Re: Adding Average Lines to Trellis https://community.qlik.com/t5/QlikView/Adding-Average-Lines-to-Trellis/m-p/1331386#M411258 <HTML><HEAD></HEAD><BODY><P>could you add your excel file please, I think you'll have to add the missing values at script level</P></BODY></HTML> Tue, 01 Aug 2017 19:25:27 GMT https://community.qlik.com/t5/QlikView/Adding-Average-Lines-to-Trellis/m-p/1331386#M411258 Anonymous 2017-08-01T19:25:27Z Re: Adding Average Lines to Trellis https://community.qlik.com/t5/QlikView/Adding-Average-Lines-to-Trellis/m-p/1331387#M411259 <HTML><HEAD></HEAD><BODY><P>Here it is. Thanks.</P></BODY></HTML> Tue, 01 Aug 2017 19:32:10 GMT https://community.qlik.com/t5/QlikView/Adding-Average-Lines-to-Trellis/m-p/1331387#M411259 Anonymous 2017-08-01T19:32:10Z Re: Adding Average Lines to Trellis https://community.qlik.com/t5/QlikView/Adding-Average-Lines-to-Trellis/m-p/1331388#M411260 <HTML><HEAD></HEAD><BODY><P>not sure, if 100% correct, but I think the basic idea should be clear ...</P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/172106_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Tue, 01 Aug 2017 19:57:52 GMT https://community.qlik.com/t5/QlikView/Adding-Average-Lines-to-Trellis/m-p/1331388#M411260 Anonymous 2017-08-01T19:57:52Z Re: Adding Average Lines to Trellis https://community.qlik.com/t5/QlikView/Adding-Average-Lines-to-Trellis/m-p/1331389#M411261 <HTML><HEAD></HEAD><BODY><P>or use a separate calendar....</P></BODY></HTML> Tue, 01 Aug 2017 20:06:00 GMT https://community.qlik.com/t5/QlikView/Adding-Average-Lines-to-Trellis/m-p/1331389#M411261 Anonymous 2017-08-01T20:06:00Z Re: Adding Average Lines to Trellis https://community.qlik.com/t5/QlikView/Adding-Average-Lines-to-Trellis/m-p/1331390#M411262 <HTML><HEAD></HEAD><BODY><P>Thanks for the suggestions Robin. Is there any way to calculate the averages without changing the script? I was hoping this could be done by writing an expression.</P><P></P><P>Thanks</P></BODY></HTML> Thu, 03 Aug 2017 14:13:16 GMT https://community.qlik.com/t5/QlikView/Adding-Average-Lines-to-Trellis/m-p/1331390#M411262 Anonymous 2017-08-03T14:13:16Z Re: Adding Average Lines to Trellis https://community.qlik.com/t5/QlikView/Adding-Average-Lines-to-Trellis/m-p/1331391#M411263 <HTML><HEAD></HEAD><BODY><P>I don't think that it is possible without changing the script because the values just don't exist for 2014...</P><P></P><P>(could be that&nbsp; I am wrong <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> )</P><P></P><P>For this chart type there's no "populate missing" option as it exists for pivot charts.</P></BODY></HTML> Thu, 03 Aug 2017 16:09:11 GMT https://community.qlik.com/t5/QlikView/Adding-Average-Lines-to-Trellis/m-p/1331391#M411263 Anonymous 2017-08-03T16:09:11Z