Display average in graph

[pooja_sn]

Hi,

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=' ?

[Gysbert_Wassenaar · Accepted solution]

On the presentation tab you can add a reference line with the label you like. See attached qvw

[pooja_sn]

Yes. but I am not able to write the expression for average properly. I have done 'count({<v2={'TRUE','true'}>}[OrderId]) ' for Totals .

[Anil_Babu_Samineni]

Why are you using two true's from expression

count({<v2={'TRUE','true'}>}[OrderId])

[pooja_sn]

because the raw data had the values in difference cases.

[Anonymous]

Hi Pooja,

You cannot change trendline name, but you can create your own trendline on presentation tab. See attached.

Regards!