Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
pooja_sn
Contributor

Display average in graph

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

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Display average in graph

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


talk is cheap, supply exceeds demand

View solution in original post

5 Replies
MVP & Luminary
MVP & Luminary

Re: Display average in graph

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


talk is cheap, supply exceeds demand

View solution in original post

pooja_sn
Contributor

Re: Display average in graph

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

Highlighted

Re: Display average in graph

Why are you using two true's from expression

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
pooja_sn
Contributor

Re: Display average in graph

because the raw data had the values in difference cases.

manucamon
Valued Contributor III

Re: Display average in graph

Hi Pooja,

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

Regards!