topic Scatter Plot Bubble Size in QlikView

Scatter Plot Bubble Size

Tue, 23 Aug 2016 16:03:01 GMT

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

Re: Scatter Plot Bubble Size

Anil_Babu_Samineni — Tue, 23 Aug 2016 17:28:47 GMT

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

Re: Scatter Plot Bubble Size

Tue, 23 Aug 2016 18:00:08 GMT

Anil Babu wrote:

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

Please see attached.

Re: Scatter Plot Bubble Size

vishsaggi — Tue, 23 Aug 2016 18:26:17 GMT

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.

Re: Scatter Plot Bubble Size

Tue, 23 Aug 2016 18:45:04 GMT

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 ID	Total Months Exposure	# of Times Revised
1	20	2
2	20	2
3	18	3
4	18	3
5	18	3
6	5	0

Re: Scatter Plot Bubble Size

Wed, 24 Aug 2016 13:58:19 GMT

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:

Re: Scatter Plot Bubble Size

vishsaggi — Wed, 24 Aug 2016 18:35:54 GMT

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

= RecommendationID

Re: Scatter Plot Bubble Size

vishsaggi — Wed, 24 Aug 2016 18:43:10 GMT

Or use = Avg(BubbleSize)

Re: Scatter Plot Bubble Size

Wed, 24 Aug 2016 18:44:44 GMT

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.

Re: Scatter Plot Bubble Size

vishsaggi — Wed, 24 Aug 2016 20:35:58 GMT

Try this and see.

= Avg(Aggr(MonthsExposure, RecommendationID))