topic Reference line on Trellis sub-graph in QlikView

Reference line on Trellis sub-graph

Fri, 16 Nov 2012 04:05:20 GMT

Attached is a sample qvw and an excel data file that I want to demonstrate my question.

I have drawn a horizontal reference line on the average of the overall score for each sub-graph and shown in the attached qvw file.

However, I hope I’ll be able to draw a reference line on the average of the each sub-graph, i.e. respective A1, A2 and A3’s average score on each sub-graph.

Any advice?

Re: Reference line on Trellis sub-graph

Fri, 16 Nov 2012 05:36:08 GMT

hai ,

I hope this is what you want,or reply me back.

Thanks

Re: Reference line on Trellis sub-graph

Fri, 16 Nov 2012 05:48:43 GMT

Hi, this is what I want. Thanks.

One more question: how to show the average in 2 decimal places on the red average line.

Re: Reference line on Trellis sub-graph

Fri, 16 Nov 2012 06:01:46 GMT

Hai,

Please find the attachment.

Re: Reference line on Trellis sub-graph

Fri, 16 Nov 2012 06:19:31 GMT

Hi, I mean that I want to show the value of the red line in 2 decimal places. If I select "Show Equation", it will show "y = ........" in 3 decmial places. If not select "Show Equation", it won't show any value of the red line.

Thanks for your advice.