topic Re: Bubble Chart in QlikView

Bubble Chart

Mon, 13 May 2013 15:16:35 GMT

Hello,

I'm trying to develop a bubble chart based on 3 different factors but am having an issue with one of the requirements.

Using the table below I want to have Company as the dimension, Value1 as the x axes and Value2 as the y axes. Value 3 will determine the size of the bubble. I can develop this fine, but the requirement is that when the values are identical for suppliers (e.g. Company D and Company E below) that the bubbles don't overlap. I'm not entirely sure if this is possible when there are limited ranges (i.e. each Value has a range 1-3), any help will be much appreciated.

Thanks,

Ralph

Company	Value1	Value2	Value3
Company A	1	2	3
Company B	2	3	1
Company C	3	1	3
Company D	2	1	2
Company E	2	1	2
Company F	3	1	3

Re: Bubble Chart

nagaiank — Mon, 13 May 2013 15:40:49 GMT

You may spread the value of Value1 and Value2 around their current value to avoid overlap.

A sample implementation is attached.

Re: Bubble Chart

Mon, 13 May 2013 15:54:42 GMT

Thanks for that. Unfortunately it skews the data as Company D & E have the same values but looking at the bubble chart they don't really look like they do have the same values. To be honest I don't think Qlikview will be able to not the overlapping based on the limited rangess.

Appreciate the help,

Ralph

Re: Bubble Chart

ankitaag — Mon, 27 Apr 2015 12:17:30 GMT

Overlapping will obviously happen if you have the same values..

Unfortunately you can't deal with it