topic Re: Bubble Chart in QlikView

Bubble Chart

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

Hi,

I am stuck at Bubble chart.

Please find attachment and see the Sheet1, I have dimension is Name and i want to create one bubble chart with Y-Axis is score of avg with two exclude names like Key Message Delivery, Sales Objective Category.

And I want to show bubble is Count(groupObservation).

I want to see very clear with bubble size accuracy Good.

- Anil

Re: Bubble Chart

susovan — Thu, 23 Jun 2016 06:52:31 GMT

Hi Anil,

Is it your requirement?

Re: Bubble Chart

Anil_Babu_Samineni — Thu, 23 Jun 2016 06:53:14 GMT

Can you please send the qvw

Re: Bubble Chart

susovan — Thu, 23 Jun 2016 06:55:21 GMT

PFA

Re: Bubble Chart

Anil_Babu_Samineni — Thu, 23 Jun 2016 07:04:41 GMT

As per client requirement,

Dimension is Name(X-Axis)

Expressions:

1) Y Axis - Average of Score ( so, here i want exclude those two names)

2) Z Axis - Count of groupObservation

- Anil

Re: Bubble Chart

avinashelite — Thu, 23 Jun 2016 07:08:51 GMT

To exclude try like this

Avg({<Name={'*'}-{'Key Message Delivery', 'Sales Objective Category'}>}Score)

Avg({<Name - ={'Key Message Delivery', 'Sales Objective Category'}>}Score)

Re: Bubble Chart

Anil_Babu_Samineni — Thu, 23 Jun 2016 07:12:33 GMT

I tried this, But still chart showing the values.

PFA.

- Anil

Re: Bubble Chart

avinashelite — Thu, 23 Jun 2016 07:16:20 GMT

Could you share the screen shots which demonstrates the issue with dimension and expression because i don't have the QV license

Re: Bubble Chart

jonathandienst — Thu, 23 Jun 2016 07:17:53 GMT

You need to exclude from the second expression as well:

Avg({<name -={'Key Message Delivery', 'Sales Objective Category'}>} Score)

Count({<name -= {'Key Message Delivery','Sales Objective Category'}>} groupObservation)

Re: Bubble Chart

Anil_Babu_Samineni — Thu, 23 Jun 2016 07:25:39 GMT

How to increase the Bubble size?

Re: Bubble Chart

MayilVahanan — Thu, 23 Jun 2016 07:33:12 GMT

Try like this

Count({<name -= {'Key Message Delivery','Sales Objective Category'}>} groupObservation) in "Z" Axis to show the bubble based on "Count"

Re: Bubble Chart

Anil_Babu_Samineni — Thu, 23 Jun 2016 07:36:52 GMT

I got the solution from jontydkpi. Unfortunately, I forget to apply the Z-axis

I am expecting Bubble size - I want to increase my bubble size?

Re: Bubble Chart

Anil_Babu_Samineni — Thu, 23 Jun 2016 07:47:31 GMT

Got It..