Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Scatter Plot Bubble Size

Background:

We issue recommendations to our clients and we track how long it takes them to rectify the issue (Months Outstanding) and how many times they change the target date to close out the recommendation (# of times revised).  Based on those two factors (expressions) I have created a scatterplot chart with a dimension of Recommendation ID.  It works perfect, I even define the color of the bubbles based on a formula to express criticality. 

Question:

The only issue is that I can have multiple recommendation ids that have the same Months outstanding and # of times revised and I want to make the bubble larger based on how many recommendations have the same combinations of Months outstanding and # of times revised.

Any help you could provide would be greatly appreciated,

Chad   

9 Replies

Re: Scatter Plot Bubble Size

I am not sure if I understand your thread, can you please share your sample qvw

Not applicable

Re: Scatter Plot Bubble Size

Anil Babu wrote:

I am not sure if I understand your thread, can you please share your sample qvw

Please see attached.

vishsaggi
Esteemed Contributor III

Re: Scatter Plot Bubble Size

YOu can increase the bubble size here: Just click on Advanced mode in expression tab on bottom left corner you can see this window and give your expression.

Capture.PNG

Not applicable

Re: Scatter Plot Bubble Size

I am aware that I can change the size using the Bubble size expression but I don't know what expression to use to get the results I need.  I want the bubble to increase in size based on the total number of recommendations that have the same 'Total Months Exposure" and '# of Revisions' .  The table below would produce 3 bubbles on the chart I want ID 6 to be the smallest bubble, ID 1 & 2 a little bigger and ID 3,4 & 5 the biggest.

   

Recommendation IDTotal Months Exposure# of Times Revised
1202
2202
3183
4183
5183
650
Not applicable

Re: Scatter Plot Bubble Size

Just to be more clear I want the highlighted bubble on the picture below to have a larger bubble because three different recommendations ids have the exact same months outstanding and times revised.  See below:

vishsaggi
Esteemed Contributor III

Re: Scatter Plot Bubble Size

Did you try putting in RecommendationID in the bubble size expression and check ?

= RecommendationID

vishsaggi
Esteemed Contributor III

Re: Scatter Plot Bubble Size

Or use = Avg(BubbleSize)

Not applicable

Re: Scatter Plot Bubble Size

Yes, that just increases the bubble size based on the ID number.  In the example above, I would like the bubble to count 3 observations and then increase size accordingly compared to another bubble that only has one observation.

vishsaggi
Esteemed Contributor III

Re: Scatter Plot Bubble Size

Try this and see.

= Avg(Aggr(MonthsExposure, RecommendationID))