topic Re: Bubble size in grid chart in QlikView

Bubble size in grid chart

Anonymous — Fri, 26 Dec 2014 05:39:09 GMT

Hi,

I am creating a grid chart which shows the time taken to open a webpage. I want to control the bubble size in such a way that whichever location takes the least time, the bubble size should be maximum and the ones where value is higher, bubble size should be smaller. Is this possible?

Regards,

Greeshma

Re: Bubble size in grid chart

Fri, 26 Dec 2014 05:56:10 GMT

Take third dim

Re: Bubble size in grid chart

amit_saini — Fri, 26 Dec 2014 05:59:55 GMT

Hi ,

Here you can change the size:

Re: Bubble size in grid chart

Anonymous — Fri, 26 Dec 2014 07:12:05 GMT

Hi,

Here i can only set the max size for the bubble. I want the bubble size to be maximum for the lowest expression value and smaller bubble for highest value. For eg if expression returns 123 bubble size will be 5, if values is 90 bubble size as 4 and so on. As the expression value increases bubble size should decrease.

Re: Bubble size in grid chart

amit_saini — Fri, 26 Dec 2014 07:20:25 GMT

Hi,

I don't think so it is possible to reverse the size of bubbles . For big number bubble size will be bigger .

Thanks,
AS

Re: Bubble size in grid chart

alkesh_sharma — Fri, 26 Dec 2014 07:35:08 GMT

change your expression into negative values

for Examples if your expression is

Sum(Value)

change it to Purgerchar(Sum(Value)*-1,'-')

now the 123 will change to -123 and 90 will change to -90 but because of the purge char function the output will remain 123 and 90.

here -90 is greater than -123 therefore your bubble size will also get reversed.

Hope this helps

Re: Bubble size in grid chart

Anonymous — Fri, 26 Dec 2014 08:03:41 GMT

Thanks Alkesh but this did not work. Nothing changed when I multiplied by -1. Seems like the negative sign is not considered.

Re: Bubble size in grid chart

alkesh_sharma — Fri, 26 Dec 2014 08:37:00 GMT

than reverse bubble size won't be possible.

Re: Bubble size in grid chart

MarcoWedel — Fri, 26 Dec 2014 09:22:37 GMT

Please post sample app to demonstrate.