topic Re: List Box to determine the bubble size from a scatter chart in QlikView

List Box to determine the bubble size from a scatter chart

danialier — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

Does anyone know how to create a list Box to determine the bubble size from a scatter chart ?

thks,dani

swuehl — Thu, 09 Jun 2016 10:58:07 GMT

Could you detail your requirements a bit closer?

Do you just want to show the third expression value per dimension?

Use a field expression in your list box:

=Aggr( YourBubbleSizeExpressionFromScatterChart, YourDimensionFromScatterChart)

danialier — Thu, 09 Jun 2016 11:13:18 GMT

Hi Swuehl,

I'd like to have a list box (or another object) where to be able to select a bubble size from a list of different types of bubble sizes.

Doing this way when looking a WW map I can select a bubble size and then when zooming-in at country level I can select another bubble size.

Do you know if that is possible?

Thks,dani

swuehl — Thu, 09 Jun 2016 11:39:56 GMT

Yes, might be possible using a field expression (select <expression> from field drop down on general tab of the list box properties), like

=Aggr( Sum(Sales), CustomerID)

Replace the expression and dimension according to your setting.

You can't really get the bubble size, but you can create kind of buckets for the bubble expression in the scatter chart as well as the list box:

Round((Sum(Sales)-Min(Total Sales)) / (Max(Total Sales) - Min(Total Sales))*10)

Anonymous — Thu, 09 Jun 2016 11:40:23 GMT

Hi Dani,

Why do you want to use a list box?

I think that is better to use a Slider with a variable, and use this variable to get bubble size.

Kind regards!