How to show value and its average in the same graph?

[#1]

Hi,

I need to show particular value and average(exponential trendline) of all values in the same chart. Is this possible? If yes, how may I do that.

e.g.

Product   SW             CD    Avg

A               1.1,1.2       20     25 

B               1.2,2.1      10      25

C               1.2,1.3      30      25

Graph should show CD for all products and average value(one line) of CD as exponential trend line

Thanks in advance,

Sumita

[Gysbert_Wassenaar]

See attached qvw. I've added AVG as an expression and I've added a reference line with value 15. Maybe the reference line option is what you're actually looking for. That's why I added it. I hope this helps.

[#3]

Hi Gysbert,

Thanks for your reply but this is not exactly what I want.

Please see the attached file. I have created two graphs but I need that in

one graph. Value and its avarage plotted in the same graph.

Thanks,

Sumita

On Mon, Oct 29, 2012 at 5:45 PM, Gysbert Wassenaar <qcwebmaster@qlik.com

[#4]

Hi,

see attached.

I've checked average in trendlines in ur first chart.

Is that what u need?

Regards

[Gysbert_Wassenaar]

See attached qvw. This method works for a limited set of products and you must select one or more products.