topic Re: Reference Circle in Scatter Chart in QlikView

Reference Circle in Scatter Chart

prabhu0505 — Thu, 21 Jan 2016 21:42:11 GMT

I have a chart like Image-1 I want to add a couple of reference circles to it and make it look like image 2.

Appreciate any help!

swuehl — Thu, 21 Jan 2016 21:44:11 GMT

Maybe just use an image as frame background (on Colors tab, AFAIR)?

prabhu0505 — Thu, 21 Jan 2016 21:54:27 GMT

Reference circle radius should be dynamic.

sebastianlettner — Fri, 22 Jan 2016 10:43:53 GMT

Hi,

you could add two expressions to the chart (if it's a line chart) for a circle.

But you need a numeric X-Axis

1. Circle half top

sqrt(pow(vRadius, 2) + 0.000000001 - pow(X-Axis, 2))

2. Circle half bottom

-sqrt(pow(10, 2) + 0.000000001 - pow(X-Axis, 2))

Or, if you need an ellipse use this expressions

1. Ellipse half top

Sqrt(Pow(vRadiusY, 2)*(1-Pow((X-Axis), 2)/Pow(vRadiusX,2)) + 0.000000001)

2. Ellipse half bottom

-Sqrt(Pow(vRadiusY, 2)*(1-Pow((X-Axis), 2)/Pow(vRadiusX,2)) + 0.000000001)

(See attached .QVW)

Otherwise I think this is not possible.

Regards

Sebastian Lettner

prabhu0505 — Mon, 25 Jan 2016 20:37:01 GMT

Your answer has opened few doors for me, trying with those. Thanks!