topic Re: Relative Bubble Size in QlikView

Relative Bubble Size

Mon, 07 May 2012 07:59:20 GMT

Hi,

I'm trying to figure out how to change the relative size of the bubbles. As the values that determine the size of bubbles are relatively close, hence making the size of bubbles very similar. How can I edit the relative size of the bubbles? Changing the Max size of bubble does not help.

Thanks!

Relative Bubble Size

Mon, 07 May 2012 08:40:21 GMT

There is a Max Bubble Size setting on the Presentation tab of properties (Disable Autosize Symbols) that you should do what you want.

Regards,

P.Prasath

Relative Bubble Size

Mon, 07 May 2012 08:45:16 GMT

Hi Prasath, it didn't turn out well. I tried but all bubbles grew together and overcrowded the chart. I could hardly tell the size difference.

Wynn

Re: Relative Bubble Size

subin6600 — Mon, 07 May 2012 10:53:10 GMT

Hi,

You could probably select different styles as shown in the below screenshot. What I feel here you have selected the style for all the bubles to be in the same size and not relative.

Regards,

Subin

Relative Bubble Size

rwunderlich — Mon, 07 May 2012 19:49:30 GMT

you can calculate a value for the bubble size that increases the relative difference. A simple example would be:

=sum(value) - max(TOTAL value) + .01

other formulas are possible, depending on how you want to visually represent the spread.

-Rob

Relative Bubble Size

Tue, 08 May 2012 00:23:06 GMT

Thanks Rob!

It works! As the values ranges from 60-90, I deduct a 50 from the value in the formula.

Re: Relative Bubble Size

Tue, 26 Feb 2013 22:20:54 GMT

Hi Rob,

Ooh I want that solution. Where do I put the formula?

Thanks!

Re: Relative Bubble Size

rwunderlich — Wed, 27 Feb 2013 01:02:56 GMT

The bubble size is the 3rd expression in the scatter chart.

-Rob

Re: Relative Bubble Size

Wed, 27 Feb 2013 09:54:44 GMT

Found it.

I started using Google Maps within QVdocs and wanted to change the size of the bubbles on the map. Knew it should be the 3rd but it wasn't working. Turns out that I had to change the dimension...

Re: Relative Bubble Size

Fri, 02 Aug 2013 04:44:07 GMT

Hi Rob,

In the 3rd expression i am using 3 conditons to plot the bubbles in 3 different sizes i.e, HIGH, MID , LOW size.

eg: if(A='LOW',20,

if(A='MID',50,

if(A='HIGH',90)))

problem here is when all 3 values are present i.e, greater than 0. it works fine.

but when any one value is 0 then bubble size shifts by one level up.

Eg: 1. When HIGH value is 0 then MID bubble will plot in the size of HIGH and LOW bubble will plot in the size of MID.

2. if MID and HIGH both values are 0. then LOW bubble will plot in the size of HIGH.

Expection is respective bubbles should always plot in the size given in the conditon rather than automatically resize itself.

can you help on this please ?

Thanks in advance.

Re: Relative Bubble Size

infock12 — Wed, 07 Oct 2015 13:00:07 GMT

Hi Rob,

I am using a grid chart have only one expression, which is =count(No:). Is it still possible to modify the size of the bubble?

Re: Relative Bubble Size

abhalla2 — Sun, 28 Apr 2019 09:40:34 GMT

There are 2 measures for scatter plot one for X-axis and another for Y-axis, just add the third and that would be treated as Bubble size expression

Hope this would help!