topic Re: Bubble Chart Color Issue!!!!!!!!!! Please help experts in QlikView

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

Anonymous — Thu, 08 Sep 2016 15:31:14 GMT

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

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

krishnacbe — Thu, 08 Sep 2016 16:34:07 GMT

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

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

vishsaggi — Thu, 08 Sep 2016 16:57:53 GMT

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

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

Anonymous — Tue, 13 Sep 2016 14:05:07 GMT

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

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

krishnacbe — Tue, 13 Sep 2016 15:58:11 GMT

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

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

vishsaggi — Tue, 13 Sep 2016 16:09:13 GMT

In the expression tab of your bubble chart like :