Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
Hi,
see attached.
I've checked average in trendlines in ur first chart.
Is that what u need?
Regards
See attached qvw. This method works for a limited set of products and you must select one or more products.