Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Bubble Chart Color Issue!!!!!!!!!! Please help experts

Good morning experts,

I have created a bubble chart. The issue i am having is that i cannot find the proper way to color these bubbles according to what is selected in my list box. For Example: If i check Assigned on my list box, i want the bubbles corresponding to what i selected to turn green. And if I check Cancelled, i want all the cancelled jobs in the bubble to turn red, and so on.

Please help experts

5 Replies
krishnacbe
Partner - Specialist III
Partner - Specialist III

Hi

Write your color expression in Colors Tab -> Data Appearance -> Colors -> Calculated box.

vishsaggi
Champion III
Champion III

Did you try this expression in your expression like:

When you click on small + sigh in the expression -> in the background color

= Pick(Match(Listboxname, 'Assigned', 'Cancelled'), Green(), LightRed())

Anonymous
Not applicable
Author

Can you show a example please if you dont mind. I am new to Qlikview

krishnacbe
Partner - Specialist III
Partner - Specialist III

Add the expression in the Calculated box. you need to add in all the Colors (1-6) , (7-12) & (13 - 18)

As suggested by Vish you can use the expression

=Pick(Match(Listboxname, 'Assigned', 'Cancelled'), Green(), LightRed())

sample.JPG

vishsaggi
Champion III
Champion III

In the expression tab of your bubble chart like :

Capture.PNG