Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
NavinReddy
Creator II
Creator II

Color based on %

Dear Experts,

i have google map based on percentage i want to give bubble colors

not sure where im doing wrong i not getting colors on map

please help me on this error

for reference i have attached sample application

Best Regards,

Niranjan

1 Solution

Accepted Solutions
tresesco
MVP
MVP

  1. Presentation tab-> Uncheck 'Pop-up Labels'
  2. Expression tab-> Select your expression 'P1Month'-> Check 'Text as pop-up'

View solution in original post

12 Replies
anagharao
Creator II
Creator II

Hi Niranjan,


Please use column() function to specify which column value you want to check and equate a color to.

tresesco
MVP
MVP

Instead of using the background color for your P1Month expression use it for Longitude. It should work. One more thing, I notice values for your variable is same 102.98 for all states. Is that right?

NavinReddy
Creator II
Creator II
Author

Hi Tresesco,

Thanks for your reply,

yes the is for all the states for rolling 3 months

how can i validate the map is displaying only 3months values

please suggest me

Best regards,

Niranjan

tresesco
MVP
MVP

Now it's a different question. Well, you can check your monthly data at state level and check if the latest three months data is summing up to 102.82 or not.

NavinReddy
Creator II
Creator II
Author

Actually my concern is based on bubble i want to display 3months information of sales

but bubble is displaying different information

i can see longitude and latitude information bubble

Any suggestion how to display expression information on bubble. please help me on this error

Thanks,

Niranjan

NavinReddy
Creator II
Creator II
Author

Good Morning to All,

i want to display expression value on google map bubble

Any suggestions

Best Regards,

Niranjan

vsudhakar
Creator III
Creator III

in two ways to give the colour to select the custom format cell (cltrl g) than select partcular cell to give condition in the condition which way you want

NavinReddy
Creator II
Creator II
Author

Hi Sudhakar,

Thanks for your reply

i want to display expression values on bubble

Untitled.png

now on bubble im getting longitude and latitude, but i want to display values

Best Regards,

Niranjan

tresesco
MVP
MVP

  1. Presentation tab-> Uncheck 'Pop-up Labels'
  2. Expression tab-> Select your expression 'P1Month'-> Check 'Text as pop-up'

View solution in original post