Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Anil_Babu_Samineni

Bubble Chart

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
1 Solution

Accepted Solutions
Anil_Babu_Samineni
Author

Got It..

Got It.PNG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

12 Replies
susovan
Partner
Partner

Hi Anil,

Is it your requirement?

16.JPG

Warm Regards,
Susovan
Anil_Babu_Samineni
Author

Can you please send the qvw

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
susovan
Partner
Partner

PFA

Warm Regards,
Susovan
Anil_Babu_Samineni
Author

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
avinashelite

To exclude try like this

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

or

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

Anil_Babu_Samineni
Author

I tried this, But still chart showing the values.

PFA.

- Anil

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
avinashelite

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

jonathandienst
Partner
Partner

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)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anil_Babu_Samineni
Author

How to increase the Bubble size?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)