Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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=' ?
On the presentation tab you can add a reference line with the label you like. See attached qvw
On the presentation tab you can add a reference line with the label you like. See attached qvw
Yes. but I am not able to write the expression for average properly. I have done 'count({<v2={'TRUE','true'}>}[OrderId]) ' for Totals .
Why are you using two true's from expression
count({<v2={'TRUE','true'}>}[OrderId])
because the raw data had the values in difference cases.
Hi Pooja,
You cannot change trendline name, but you can create your own trendline on presentation tab. See attached.
Regards!