Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pooja_sn
Creator
Creator

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
Gysbert_Wassenaar

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
Gysbert_Wassenaar

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
Creator
Creator
Author

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])

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
Creator
Creator
Author

because the raw data had the values in difference cases.

manucamon
Specialist III
Specialist III

Hi Pooja,

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

Regards!