topic Re: Get chart coordinates via VBScript in QlikView

Get chart coordinates via VBScript

Wed, 14 Sep 2011 11:52:22 GMT

Hi to all,

in these days I'm facing to this problem.

I have a scatter chart with two expressions as coordinates.

What I want to do is to get the values of the coordinates on the chart showed in the bottom left corner of QlikView screen.

In the attached image you can see the information I need.

Is there a VBSript function or something like that, that can give me back this information, please?

Thanks in advance for your help.

Best regards,

Mario Masciulli

Re: Get chart coordinates via VBScript

Wed, 14 Sep 2011 13:55:00 GMT

Something like this (don't forget to change your chart ID)? Perhaps store values in variables then put them in a text box positioned on the graph with layer = top?

sub getCoords
 set doc=ActiveDocument
 set chart = ActiveDocument.GetSheetObject("CH33")
 chartX = chart.GetProperties.GraphLayout.Frame.Rect.Left
 chartY =  chart.GetProperties.GraphLayout.Frame.Rect.Top
 msgbox("x=" & chartX & ",y=" & chartY)
end sub

Regards,

Gordon

Re: Get chart coordinates via VBScript

Wed, 14 Sep 2011 14:20:26 GMT

Hi Gordon,

thanks for your answer but what I was looking for is the couple of values related to the movement of my mouse.

I mean, if I move on my scatter chart I see in the bottom left corner of QlikView two values changing, representing each one, one of the axis (x and y).

In the file attached, for example, the value I'm looking for is: 241.39899....

Do you know any way to get these values?

Thanks again.

Regards,

Mario

Re: Get chart coordinates via VBScript

Thu, 15 Sep 2011 16:28:07 GMT

Hi to all,

does anyone have some suggestion to my question please?

I'm still facing the same problem and actually I'm not able to get the two values I see in the bottom left corner when I move on my scatter chart.

Any help is appreciated.

Thanks, regards,

Mario Masciulli

Re: Get chart coordinates via VBScript

Mon, 19 Sep 2011 08:26:34 GMT

Up!!

Re: Get chart coordinates via VBScript

Anonymous — Fri, 21 Jul 2017 14:13:35 GMT

Gordon - i believe the issue is that coordinates that are stored in Rect are not the same as those displayed by QV - in my case, 373,297 are represented as 1167,926 - i.e. everything is multiplied by 3.12.

Any idea where does this translation come from?

Re: Get chart coordinates via VBScript

Anonymous — Fri, 21 Jul 2017 14:32:46 GMT

Mario - if your issue is the same as mine - i.e. different coordinate system between values shown in the UI and from Frame.Rect - then the solution is using object.GetRect directly, without going via Frame - then the values are correct.