topic bubble size in QlikView

bubble size

Thu, 02 Dec 2010 21:10:16 GMT

Hi all,

I have a chart where bubble size depends on a count expression. Everything is fine until when I have count = 0 for all of the elements in the other dimension. I need the bubbles to disappear (instead of displayed in max size) if the count value for all the bubbles is zero. Does any one have a solution for this?

thanks in advance

bubble size

pover — Fri, 03 Dec 2010 01:54:59 GMT

A workaround would be to put an expression like the following in the background color of the first expression:

if(count(Item)=0,white())

In that way the the bubble "disappears"

Regards.

bubble size

vonpape — Mon, 20 Dec 2010 12:08:01 GMT

Hello,

i have got the same Problem. But the workaround is no solution, because many points on the map do not have a value. Has someone still another idea?

Regards.

bubble size

Mon, 20 Dec 2010 12:18:19 GMT

can you select the 'suppress Zero value' available in the 'Presentation tab' in chart properties?

bubble size

vonpape — Mon, 20 Dec 2010 12:43:26 GMT

yes. "suppress Zero values" is selected, but it does not have any effects.

bubble size

jchoucq — Mon, 20 Dec 2010 12:51:54 GMT

and what about "Suppress NULL values" in DImension Tab ?

bubble size

Mon, 20 Dec 2010 12:54:46 GMT

When I tried, all zero and null values are suppressed in the chart after selecting the 'supress zero values' and 'suppress null values'

Can you upload the document?

-Haneesh

bubble size

vonpape — Mon, 20 Dec 2010 13:40:51 GMT

Hi,

null values are also supressed, but it also doesn't have an effect. Enclosed the document.

Thanks for your help

bubble size

pover — Mon, 20 Dec 2010 19:38:14 GMT

Suppress zero and missing don't work well because X and Y still have values, so can do the following:

=if(num(Revenue, '#.##0 €;-#.##0 €') >= num(vSimvalue,'#.##0 €;-#.##0 €'),avg ())

and after a certain number on the slider QlikView will say "No Data to Display"

or else you can change the style to two-dimensional dots and put this expression in the background color of the x-expression

=if(num(Revenue, '#.##0 €;-#.##0 €') < num(vSimvalue,'#.##0 €;-#.##0 €') or isnull(num(Revenue, '#.##0 €;-#.##0 €')),white(0))

and that will present a clean map after a certain number on the slider. The 0 in the white function makes it tranparent and again it has to be the two-dimensional dot style.

Regards.

bubble size

vonpape — Tue, 21 Dec 2010 10:48:36 GMT

Excellent, Thank you