Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Bubble Chart Axes Control

Hi there, I have created a bubble chart to display 3 dimensions and I have found that I can't use the Static Min and Static Max functions.

As you can see from the image this starts to chop some of the chart - does anyone know a get around?

Bubble Chart Access Control.png

Something that could round up to the next whole number (specified amount) above the largest value?

I have provided the qvw for people as well.

Any help is appreciated.

 

Thanks

Rob

7 Replies
sujeetsingh
Not applicable

Re: Bubble Chart Axes Control

Just increase the below lenght all will be done .

Else just go to Properties<<<Presentation  and then just set MAX Bubble Size to 13 or 14 pt....?

It worked in your Sample.

Not applicable

Re: Bubble Chart Axes Control

Hi SoS that has worked to make sure the bubbles aren't chopped. Thanks

Is there a way to set the Static Max and Min that you know of?

Thanks

Rob

Not applicable

Re: Bubble Chart Axes Control

I do face the same problem, both on the upper as well as the lower side of the Y axis, as well as on the lower side of the x axis depending on some selections.

Is there any other solution than to make the bubbles smaller? I do want to have bigger bubbles as the distribution is not very even.

Not applicable

Re: Bubble Chart Axes Control

Hi Matthias, its been a while since I worked on these charts but I've just taken a look at how I got round the issue.

The main thing is instead of using a bubble chart is to use a scatter chart.

Then you have access to the min and max for each axis and also in the Chart Properties> Presentation tab you will have access to change the bubble size (top left of the dialogue box).

I ended up changing the bubbles to hoops because it allowed me to see all of the hoops even if they were stuck behind each other.  See the image below.

Hope this helps.

Scatter Chart 3 dimensions.png

Not applicable

Re: Bubble Chart Axes Control

Hello Rob

Thanks for your prompt reply. I like your suggestion to use hoops, but somehow it still cuts off part of them.

I understand that I can manually override the Min/Max values of the axis, but that is kind of counterproductive if the user should be able to make selections on dimensions/periods. And calculating the axis dimensions on the fly is making it also not very straight forward.

So do I really have to create an expression to calculate the four axis Min/Max values to show the whole picture?

Not applicable

Re: Bubble Chart Axes Control

Hi Matthias, ah I see the values you have are very broad so sadly it looks like you would have to create an expression.  That's a pain!

If you do please add to this discussion as it will help a lot of others I'm sure.

Not applicable

Re: Bubble Chart Axes Control

I wish I could. I tried, but since my chart uses a drill-down group as a dimension, I can't find the min/max values for a given selection in an expression for the axis.

I guess I just have to live with an aweful chart then for the time being.