topic Re: Bubble/Scatter charts in QlikView

Bubble/Scatter charts

Anonymous — Wed, 05 Jun 2013 07:34:08 GMT

Hello - I have the bubble chart (see attached), the bubble represents the size of the value, however in my example visually this does not look like it's representing the values correctly - has anyone come accross this before?

To clarify, the largest value is about 35%, the second is 13%, the two bubbles don't seem appropriately sized.

Re: Bubble/Scatter charts

m_woolf — Wed, 05 Jun 2013 10:15:36 GMT

It looks like the diameters of the circles are appropriate, not the areas.

Re: Bubble/Scatter charts

Anonymous — Wed, 05 Jun 2013 10:17:48 GMT

Agreed, but from a visualisation point of view I think it's a bit rubbish, I'll have to see if there is an option to get the area to represent the size and not the diameter

Re: Bubble/Scatter charts

m_woolf — Wed, 05 Jun 2013 10:52:20 GMT

It looks like sqrt(sum(PROFIT)) will show the bubble size relative to the area of the bubble, but that shows the wrong pop up text values.

Re: Bubble/Scatter charts

Wed, 05 Jun 2013 14:19:01 GMT

THere is a way to pop the good value :

presentation tab => desactivate pop up label

expression tab => desactivate the text as pop for sqrt(sum(PROFIT))

add a new expression (sum(PROFIT))

activate pop up label for the new expression