AVG Trendline Issue

[#1]

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 ?

[Gysbert_Wassenaar]

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.

[#3]

Thanks for the quick response. It doesn't seem to work.

[Gysbert_Wassenaar]

Please post a qlikview document that demonstrates the problem.

[#5 · Accepted solution]

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!!