topic Re: Relative scaling of bubble size: how to change in QlikView

Relative scaling of bubble size: how to change

Tue, 12 Jun 2012 11:59:30 GMT

I have made a grid chart with bubble reflecting the volume sold to certain customer/product combinations. It appears that the relative scaling of the bubbles is not correct. When the volume of a certain product/customer combination is twice as big, the bubble appears to be at least 4x bigger.

Two questions:

Does anybody know how the relative bubbel size is determined? Is my observation correct?
Can I change the approach used for the relative scaling of the bubbbles?

Thanks, Marc.

Re: Relative scaling of bubble size: how to change

swuehl — Tue, 12 Jun 2012 12:48:21 GMT

I assumed so far that the bubble size will scale from zero to the max bubble size set linearly, where the size will be set by the bubble size expression and the 'bubble size' will be proportional to the area of the bubble.

Well, anyway, you can use any expression as bubble size expression, so if you think the bubble appears 4x larger if your expression gives only a 2x value, just use something like

=sqrt( sum(Volume) )

i.e. calculate the square root of your values.

Hope this helps,

Stefan

Re: Relative scaling of bubble size: how to change

Wed, 13 Jun 2012 09:32:51 GMT

Hi, thanks for the reply. This is what I did, use the square root to get the proper scaling. But this has a major drawback: if you mouse over the bubbles to get the value of the bubble (which I use a lot), you get a aeamningless number. So I would prefer a different solution. Any ideas?

Re: Relative scaling of bubble size: how to change

swuehl — Wed, 13 Jun 2012 09:37:58 GMT

Try using a dual as bubble size expression outcome, something like

dual( sum(Volume), sqrt( sum(Volume) ) )

Re: Relative scaling of bubble size: how to change

Thu, 21 Jun 2012 08:14:35 GMT

Hi Stefan,

This seems to be the way to go. One detail: if I do this, the experession is sum(Volume) is not evaluated. How can I force evaluation of the expression and then display the result as a number?

Re: Relative scaling of bubble size: how to change

swuehl — Thu, 21 Jun 2012 09:41:10 GMT

Not sure what you are talking about. I do get the expression evaluated.

Could you post a small sample file?

Re: Relative scaling of bubble size: how to change

Wed, 27 Feb 2013 10:02:11 GMT

Hi MarcD,

An alternative to make sure you have the right info when you mouse over the bubble is to create a 4th expression with the desired info. Something like:

=Customername & ': number of products sold ' & ceil ( count ( distinct [Product numbers] ) ) // Pop_up text

Next, apply the option 'Text as Pop-up' under the Display Options.

This way you are able to modify and personalize the pop-up.