topic Re: Hi, I've just joined Qlik, I am trying to create a bubble chart but can't get the bubble to change size dependent on the third expression. what am I doing wrong?! I had originally a large data set but tried a simple set of 10 items and same result. in QlikView

Hi, I've just joined Qlik, I am trying to create a bubble chart but can't get the bubble to change size dependent on the third expression. what am I doing wrong?! I had originally a large data set but tried a simple set of 10 items and same result.

Fri, 06 Mar 2015 10:46:03 GMT

Hi, I've just joined Qlik, I am trying to create a bubble chart but can't get the bubble to change size dependent on the third expression. What am I doing wrong?! I had originally a large data set but in attempt to see what i was doing wrong I tried using a simple spreadsheet with only a set of 10 items (see attached) and got the same result.

Re: Hi, I've just joined Qlik, I am trying to create a bubble chart but can't get the bubble to change size dependent on the third expression. what am I doing wrong?! I had originally a large data set but tried a simple set of 10 items and same result.

hic — Fri, 06 Mar 2015 10:52:44 GMT

Re: Hi, I've just joined Qlik, I am trying to create a bubble chart but can't get the bubble to change size dependent on the third expression. what am I doing wrong?! I had originally a large data set but tried a simple set of 10 items and same result.

Gysbert_Wassenaar — Fri, 06 Mar 2015 11:05:45 GMT

I assume you meant to say you're creating a scatter chart. A bubble chart requires two dimensions. I also experienced the problem you described. The third expression sum([Z Value]) I added did not result in different bubble sizes. When I created a new document the chart worked correctly. I haven't been able to reproduce the problem again.

Re: Hi, I've just joined Qlik, I am trying to create a bubble chart but can't get the bubble to change size dependent on the third expression. what am I doing wrong?! I had originally a large data set but tried a simple set of 10 items and same result.

hic — Fri, 06 Mar 2015 11:47:54 GMT

It could be that the wrong style was chosen. You need to have one of the bottom right three.

HIC

Re: Hi, I've just joined Qlik, I am trying to create a bubble chart but can't get the bubble to change size dependent on the third expression. what am I doing wrong?! I had originally a large data set but tried a simple set of 10 items and same result.

Gysbert_Wassenaar — Fri, 06 Mar 2015 11:53:26 GMT

That wasn't the problem. The lower right style is the default. I tried the others as well. But as I said, I can't seem to reproduce it anymore.

Re: Hi, I've just joined Qlik, I am trying to create a bubble chart but can't get the bubble to change size dependent on the third expression. what am I doing wrong?! I had originally a large data set but tried a simple set of 10 items and same result.

Fri, 06 Mar 2015 19:07:45 GMT

Hi Gysbert / Henric

Firstly, thanks for your help! I have selected the scatter plot as suggested by Henric. I am looking to create a bubble chart (scatter chart with 3 dimensions, X, Y and Z). Please see the chart I currently get and what has been set up in properties. I was expecting the bubble sizes to be different as the values for that dimension are different.

Re: Hi, I've just joined Qlik, I am trying to create a bubble chart but can't get the bubble to change size dependent on the third expression. what am I doing wrong?! I had originally a large data set but tried a simple set of 10 items and same result.

Fri, 06 Mar 2015 19:16:30 GMT

Sorry, tried to paste the screenshots in but doesn't seem to have worked. I have inserted as an image below.

Re: Hi, I've just joined Qlik, I am trying to create a bubble chart but can't get the bubble to change size dependent on the third expression. what am I doing wrong?! I had originally a large data set but tried a simple set of 10 items and same result.

hic — Fri, 06 Mar 2015 21:39:46 GMT

It's not possible to say just from the picture. Everything in the picture looks OK. So I would check the following:

That the style is the right one (see my previous comment)
That the numbers really are different for the different bubbles. Maybe they are the same? Convert to a pivot table to see the numbers.

HIC

Re: Hi, I've just joined Qlik, I am trying to create a bubble chart but can't get the bubble to change size dependent on the third expression. what am I doing wrong?! I had originally a large data set but tried a simple set of 10 items and same result.

Sat, 07 Mar 2015 16:46:57 GMT

Hi Henric

The style is the one you originally suggested.

Here are the numbers, I deliberately created a simple data set (only 3 columns of 10 rows! Original sheet was many columns and 1000s of rows). As you can see Z dimension numbers are all different, the largest being 15 times bigger than smallest:

Dimension	Y Value	X Value	Z value
A	50	80	20
B	35	40	300
C	21	35	25
D	45	90	150
E	90	10	200
F	120	75	10
G	140	120	90
H	5	15	75
I	15	26	10
J	25	10	140

Any ideas?

Alan

Re: Hi, I've just joined Qlik, I am trying to create a bubble chart but can't get the bubble to change size dependent on the third expression. what am I doing wrong?! I had originally a large data set but tried a simple set of 10 items and same result.

rwunderlich — Sat, 07 Mar 2015 18:47:45 GMT

Try going to Presentation, uncheck "Autosize Symbols". Then increase the "max bubble size".

-Rob

Re: Hi, I've just joined Qlik, I am trying to create a bubble chart but can't get the bubble to change size dependent on the third expression. what am I doing wrong?! I had originally a large data set but tried a simple set of 10 items and same result.

Sun, 08 Mar 2015 12:59:33 GMT

Hi Rob, having it unchecked or checked is making no difference:

Re: Hi, I've just joined Qlik, I am trying to create a bubble chart but can't get the bubble to change size dependent on the third expression. what am I doing wrong?! I had originally a large data set but tried a simple set of 10 items and same result.

rwunderlich — Sun, 08 Mar 2015 16:24:32 GMT

DId you get any change in bubble size when you increased the number?

Rob

Re: Hi, I've just joined Qlik, I am trying to create a bubble chart but can't get the bubble to change size dependent on the third expression. what am I doing wrong?! I had originally a large data set but tried a simple set of 10 items and same result.

Sun, 08 Mar 2015 18:47:11 GMT

Hi Rob, yes, changing the max bubble size does indeed change the size of the bubbles but they all remain the same size. They should be varying sizes relative to their Z score. Alan

Re: Hi, I've just joined Qlik, I am trying to create a bubble chart but can't get the bubble to change size dependent on the third expression. what am I doing wrong?! I had originally a large data set but tried a simple set of 10 items and same result.

rwunderlich — Sun, 08 Mar 2015 21:51:01 GMT

Can you post your sample qvw?

Re: Hi, I've just joined Qlik, I am trying to create a bubble chart but can't get the bubble to change size dependent on the third expression. what am I doing wrong?! I had originally a large data set but tried a simple set of 10 items and same result.

awhitfield — Mon, 09 Mar 2015 12:17:23 GMT

Hi Alan,

check out the attached

Re: Hi, I've just joined Qlik, I am trying to create a bubble chart but can't get the bubble to change size dependent on the third expression. what am I doing wrong?! I had originally a large data set but tried a simple set of 10 items and same result.

Mon, 09 Mar 2015 23:28:26 GMT

Hi Rob

Please find attached file

Regards

Alan

Re: Hi, I've just joined Qlik, I am trying to create a bubble chart but can't get the bubble to change size dependent on the third expression. what am I doing wrong?! I had originally a large data set but tried a simple set of 10 items and same result.

Mon, 09 Mar 2015 23:30:38 GMT

Hi Andrew

Thanks for your reply, I can see it works. I'm not entirely sure though what I have being doing wrong. I have posted my file in reply to Rob. Where am I making my mistake? Once I know that I can try with the real data I want to look at, not this simple example. regards Alan

Re: Hi, I've just joined Qlik, I am trying to create a bubble chart but can't get the bubble to change size dependent on the third expression. what am I doing wrong?! I had originally a large data set but tried a simple set of 10 items and same result.

Gysbert_Wassenaar — Tue, 10 Mar 2015 08:40:41 GMT

Change your third expression from sum[Z value] to sum([Z value])

Re: Hi, I've just joined Qlik, I am trying to create a bubble chart but can't get the bubble to change size dependent on the third expression. what am I doing wrong?! I had originally a large data set but tried a simple set of 10 items and same result.

Wed, 11 Mar 2015 09:51:03 GMT

Hi Gysbert

That has done the trick. thank you. Thanks also to Andrew, Rob and Henric, between everyone it has been sorted! Will start playing with other data now and no doubt will get stuck again but at least I now know there are people there to help.

regards

Alan

Re: Hi, I've just joined Qlik, I am trying to create a bubble chart but can't get the bubble to change size dependent on the third expression. what am I doing wrong?! I had originally a large data set but tried a simple set of 10 items and same result.

awhitfield — Wed, 11 Mar 2015 10:20:58 GMT

Hi Alan,

don't forgot to mark an answer as CORECT and any USEFUL replys as such!

Andy