topic Re: Display average in graph in QlikView https://community.qlik.com/t5/QlikView/Display-average-in-graph/m-p/1181887#M885582 <HTML><HEAD></HEAD><BODY><P>Yes. but I am not able to write the expression for average properly. I have done '<SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">v2</SPAN><SPAN style="font-size: 8pt;">={'TRUE','true'}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">[OrderId]</SPAN><SPAN style="font-size: 8pt;">) </SPAN>' for Totals .</P></BODY></HTML> Mon, 26 Sep 2016 10:46:40 GMT pooja_sn 2016-09-26T10:46:40Z Display average in graph https://community.qlik.com/t5/QlikView/Display-average-in-graph/m-p/1181885#M885580 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I wish to display a graph in qlikview showing total orders per month and an average line. But when I select to display trendline from Expressions tab , average line is displayed with 'y=' expression. Is there any way to show it as 'Average=' ?</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/138654_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/138655_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Display-average-in-graph/m-p/1181885#M885580 pooja_sn 2020-11-25T16:16:04Z Re: Display average in graph https://community.qlik.com/t5/QlikView/Display-average-in-graph/m-p/1181886#M885581 <HTML><HEAD></HEAD><BODY><P>On the presentation tab you can add a reference line with the label you like. See attached qvw</P></BODY></HTML> Mon, 26 Sep 2016 10:44:36 GMT https://community.qlik.com/t5/QlikView/Display-average-in-graph/m-p/1181886#M885581 Gysbert_Wassenaar 2016-09-26T10:44:36Z Re: Display average in graph https://community.qlik.com/t5/QlikView/Display-average-in-graph/m-p/1181887#M885582 <HTML><HEAD></HEAD><BODY><P>Yes. but I am not able to write the expression for average properly. I have done '<SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">v2</SPAN><SPAN style="font-size: 8pt;">={'TRUE','true'}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">[OrderId]</SPAN><SPAN style="font-size: 8pt;">) </SPAN>' for Totals .</P></BODY></HTML> Mon, 26 Sep 2016 10:46:40 GMT https://community.qlik.com/t5/QlikView/Display-average-in-graph/m-p/1181887#M885582 pooja_sn 2016-09-26T10:46:40Z Re: Display average in graph https://community.qlik.com/t5/QlikView/Display-average-in-graph/m-p/1181888#M885583 <HTML><HEAD></HEAD><BODY><P>Why are you using two true's from expression</P><P></P><P><STRONG>count({&lt;v2={'TRUE','true'}&gt;}[OrderId])</STRONG></P></BODY></HTML> Mon, 26 Sep 2016 10:58:57 GMT https://community.qlik.com/t5/QlikView/Display-average-in-graph/m-p/1181888#M885583 Anil_Babu_Samineni 2016-09-26T10:58:57Z Re: Display average in graph https://community.qlik.com/t5/QlikView/Display-average-in-graph/m-p/1181889#M885584 <HTML><HEAD></HEAD><BODY><P>because the raw data had the values in difference cases.</P></BODY></HTML> Mon, 26 Sep 2016 10:59:50 GMT https://community.qlik.com/t5/QlikView/Display-average-in-graph/m-p/1181889#M885584 pooja_sn 2016-09-26T10:59:50Z Re: Display average in graph https://community.qlik.com/t5/QlikView/Display-average-in-graph/m-p/1181890#M885585 <HTML><HEAD></HEAD><BODY><P>Hi Pooja,</P><P>You cannot change trendline name, but you can create your own trendline on presentation tab. See attached.</P><P></P><P>Regards!</P></BODY></HTML> Mon, 26 Sep 2016 11:02:20 GMT https://community.qlik.com/t5/QlikView/Display-average-in-graph/m-p/1181890#M885585 Anonymous 2016-09-26T11:02:20Z