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

[Anonymous]

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

[krishnacbe]

Hi

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

[vishsaggi]

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]

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

[krishnacbe]

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())

[vishsaggi]

In the expression tab of your bubble chart like :