topic Re: Color based on % in QlikView

Color based on %

NavinReddy — Thu, 12 May 2016 05:27:11 GMT

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

Re: Color based on %

anagharao — Thu, 12 May 2016 06:22:20 GMT

Hi Niranjan,

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

Re: Color based on %

tresB — Thu, 12 May 2016 06:44:59 GMT

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?

Re: Color based on %

NavinReddy — Thu, 12 May 2016 07:02:59 GMT

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

Re: Color based on %

tresB — Thu, 12 May 2016 07:10:44 GMT

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.

Re: Color based on %

NavinReddy — Thu, 12 May 2016 07:39:42 GMT

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

Re: Color based on %

NavinReddy — Fri, 13 May 2016 04:11:00 GMT

Good Morning to All,

i want to display expression value on google map bubble

Any suggestions

Best Regards,

Niranjan

Re: Color based on %

Anonymous — Fri, 13 May 2016 04:22:04 GMT

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

Re: Color based on %

NavinReddy — Fri, 13 May 2016 04:29:57 GMT

Hi Sudhakar,

Thanks for your reply

i want to display expression values on bubble

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

Best Regards,

Niranjan

Re: Color based on %

tresB — Fri, 13 May 2016 04:58:00 GMT

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

Re: Color based on %

settu_periasamy — Fri, 13 May 2016 05:15:12 GMT

May be like this..

Check the Attachment

Re: Color based on %

NavinReddy — Fri, 13 May 2016 05:34:34 GMT

Hi tresesco,

Thank you so much for your reply its working

Regards,

Niranjan

Re: Color based on %

NavinReddy — Fri, 13 May 2016 05:36:26 GMT

yes exactly its working thanks for your reply

Regards,

Niranjan