topic Re: How to show value and its average in the same graph? in QlikView

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

Mon, 29 Oct 2012 07:56:53 GMT

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

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

Gysbert_Wassenaar — Mon, 29 Oct 2012 08:45:14 GMT

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.

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

Wed, 31 Oct 2012 01:27:55 GMT

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

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

Wed, 31 Oct 2012 05:03:45 GMT

Hi,

see attached.

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

Is that what u need?

Regards

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

Gysbert_Wassenaar — Wed, 31 Oct 2012 08:45:17 GMT

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