Value of Trendline in Chart

[#1]

Dear QV Friends,

I am using "QlikView 9.00 SR2".

I have a line chart and trendline of average on the same.

I want to display value at which this average lies.

I want to display it using option Chart Properties-Presentation-Text in chart using Expression (No hardcoding).

Plz suggest.

Thanks in advance.

Happy Thoughts.

[nathanfurby]

Instead of adding the 'Average' trendline on the Expressions tab go to the Presentation tab.

Click Add in the 'Reference Lines' section and enter an expression like:

AVG(amount)

Then add a label like:

='Average = ' & AVG(amount)

You can also play around with the colour/weight of the line itself.

[#3]

Hi Nathan,

Thanks for reply.

I don't want average for complete field.

I want average for selected data in that field.

e.g. If I select sales in period 5 Jan to 10 Jan out of total mont of Jan, I want for average for sales within this period.

I hope this makes my query more specific.

Happy Thoughts

[nathanfurby]

Does your chart not change based on date selections then?