topic Is there any way to programmatically set Max Bubble Size in Scatter Chart? in QlikView

Is there any way to programmatically set Max Bubble Size in Scatter Chart?

jekbauita — Fri, 20 Apr 2018 11:43:10 GMT

I'm using QlikView 11.

In Scatter Charts I know the way to set the Max Bubble Size (Presentation Tab) or to set the bubble dimension (via the Z-axis dimension).

I can't find any way to set the Max Bubble Size programmatically. For example, when printing data on a map I want the max bubble size to increase when coming in or decrease when zooming out.

I seem to can't find a way to do so, but I don't know if I'm missing something or if it's not possible at all.

Thanks in advance for any help.

Re: Is there any way to programmatically set Max Bubble Size in Scatter Chart?

m_woolf — Fri, 20 Apr 2018 12:58:23 GMT

I'm not sure if this will help:

sub SymbolSize

set v = ActiveDocument.Variables("vSymbolSize")

intSymbolSize = v.GetContent.String

set chart = ActiveDocument.GetSheetObject("CH66")

set p = chart.GetProperties

p.ChartProperties.SymbolSize = intSymbolSize

chart.SetProperties p

end sub

Re: Is there any way to programmatically set Max Bubble Size in Scatter Chart?

jekbauita — Fri, 20 Apr 2018 13:03:43 GMT

Hi m w and thanks for your reply.

I'm not very practical with subroutines, do you mind to be more specific about where should I write this code and how can I activate it? It would be very helpful for me.

I understand the logic of what you wrote and if you can point out some resource I'm sure to find a way to solve my problem. It would be fun to learn a new technique as well.

Thank you again.

Re: Is there any way to programmatically set Max Bubble Size in Scatter Chart?

m_woolf — Fri, 20 Apr 2018 13:11:20 GMT

This is a vbscript macro.

You open the macro editor (Ctrl+M) and paste the script.

Then add an input box with a variable named vSymbolSize (to match the name in the code).

Finally you set an OnInput trigger on the variable with an action that runs the macro (SymbolSize)