Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I am not able to draw a AVERAGE Trendline for the below chart. The problem is the chart is showing 2 Average Trendline for different products. I only want to show 1 Average Trendline for the total products. Anyone out there able to advise ?
Hi Gysbert,
The Average Trendline comes out nicely, after I did some changes to the Expression. Your suggestion is good and I only need to make some changed. THANKS A LOT!!
Add one reference line on the Presentation tab using this expression: =avg(aggr( avg(Amount), Trade_Month_Year)). Replace avg(Amount) with the expression you use for the bar segments.
Thanks for the quick response. It doesn't seem to work.
Please post a qlikview document that demonstrates the problem.
Hi Gysbert,
The Average Trendline comes out nicely, after I did some changes to the Expression. Your suggestion is good and I only need to make some changed. THANKS A LOT!!