Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Changing Bubble Colors on Maps

I have a map created with 5 data points. The pin(bubble) color is the same for each of the 5 data points.  What i would like to do is put in a statement that gives me three different colors.  If the total estimate 5000 then green, if total estimate 3000 then yellow and if total estimate 1000 then red.  Can this be done and if so can someone help me out.

Thanks,

David

1 Solution

Accepted Solutions
jsaradhi
Valued Contributor

Re: Changing Bubble Colors on Maps

instead of the expression you currently have for the background color of longitude, use below for the requirement you have in your first post. adjust accordingly to meet your specific needs:

if(TotalEstimate=5000,rgb(0,255,0), if(TotalEstimate=3000, rgb(255,255,0),rgb(255,0,0)))

12 Replies
jsaradhi
Valued Contributor

Re: Changing Bubble Colors on Maps

what map extension are you using?

Not applicable

Re: Changing Bubble Colors on Maps

I am not using one.  I have not tried extensions.  I am not sure how they work or how you set them up. 

sudeepkm
Valued Contributor III

Re: Changing Bubble Colors on Maps

Can you please post a sample QVW? I've created a Google static map in the past using a Scattered chart where we were displaying RAG per location (At least one RED will be visible else Yellow or Green).

Not applicable

Re: Re: Changing Bubble Colors on Maps

Here is my sample data. 

jsaradhi
Valued Contributor

Re: Changing Bubble Colors on Maps

instead of the expression you currently have for the background color of longitude, use below for the requirement you have in your first post. adjust accordingly to meet your specific needs:

if(TotalEstimate=5000,rgb(0,255,0), if(TotalEstimate=3000, rgb(255,255,0),rgb(255,0,0)))

Not applicable

Re: Changing Bubble Colors on Maps

Thank you for your help.  I am still learning about maps so I never changed the background color of longitude so I dont know where it is.  Can you point it out as I wait I will play around with it. 

Not applicable

Re: Changing Bubble Colors on Maps

Nevermind.  Temporary Brain Freeze.  Thanks for you help.

David

jsaradhi
Valued Contributor

Re: Changing Bubble Colors on Maps

we have all been there

glad could help!

Not applicable

Re: Changing Bubble Colors on Maps

I Do have one more question can you put a conditional format that when you select a bubble a chart pops up. I have done it with list boxes and charts.

Community Browser