topic Re: Google Maps - LA in QlikView

Google Maps - LA

Thu, 02 Jan 2014 06:09:14 GMT

Hi,

i have a project wherein i have to show the sales drop rate for various Latin America countries on Google map. I have tried to replicate the maps from the below link (Google maps sheet)

http://community.qlik.com/docs/DOC-5486

i have attached my excel version wherein the drop rate for each country is represented by a color code. I am facing teh following challenges:

1- The bubbles on the chart don't represent that particular country. The bubble for Mexico is way down then where actual Mexico is located and the same applies for all region

2- the y axis is not hidden even though i have selected the option for hidden

3- When i put the dynamic axis as shown in the example in the above link, the bubbles disappear

4- The size of the bubble should represent the drop rates. As of now all seem to be of the same size

I would really appreciate if someone can help me on this.

Thanks in advance

Re: Google Maps - LA

sujeetsingh — Thu, 02 Jan 2014 06:39:56 GMT

See this now

Re: Google Maps - LA

Thu, 02 Jan 2014 09:17:44 GMT

Hi Sujeet,

thanks a ton for your reply.

Only 1 request is pending...

How we can keep the bubble size based on the drop rates. For eg: if drop rate is 8 then bubble must be big, if its 1 it should be very small and so on.

Also, i need 2 replicate this map for 3 other metrics. Just the drop rates would be different. Instead of bubbles, is there any other way of presenation so that it looks different from the 1st one.

Thanks a ton.

Re: Google Maps - LA

sujeetsingh — Thu, 02 Jan 2014 09:30:09 GMT

Yosuf it seems that the option for this is not working

In properties tab >>>Style Tab you can get different ways of symbols for datapoints

Re: Google Maps - LA

Thu, 02 Jan 2014 09:34:50 GMT

instead of that as an alternative, can we do play with the background color.

If value is from 0 to 3 then bubble color to be blue, if its 4 to 7 then tellow and anything above 7 to be red.

Thanks a ton.

Re: Google Maps - LA

Thu, 02 Jan 2014 09:44:54 GMT

it seems the problem is with the drop rates expression.

If i put an ')' at the end the bubbles disappear. also i cant view the values for each country on mouse over. Can you please look into this.

Re: Google Maps - LA

sujeetsingh — Thu, 02 Jan 2014 09:47:27 GMT

Yes of course

At expression + sing click

then comes option for Backgound and there write this expression

if(Sum ([Drop Rate])>=0 or Sum ([Drop Rate])>=3,blue(),

if(Sum ([Drop Rate])>=4 or Sum ([Drop Rate])>=7,Yellow(),LightRed()))

If it helps you then make this question with valid status .

Re: Re: Google Maps - LA

Thu, 02 Jan 2014 09:58:09 GMT

I really apprecaite your assistance. Now i can see onlu bubbles in blue. PFA the qvw file for your reference. Also why my 'Drpp rate' expression is not returning any value? i have used sum([Drop Rate]

thanks a ton for your assistance. i need to deliver this in 1 hour. hope we fix this by then.

Re: Google Maps - LA

sujeetsingh — Thu, 02 Jan 2014 10:19:21 GMT

http://community.qlik.com/docs/DOC-3136

Go to this link and then carry on the next work

Re: Google Maps - LA

Thu, 02 Jan 2014 10:36:31 GMT

That link shows how to craete a map and i have already created one. so i dont think referring to that will help.

What i need is the background color of the bubbles based on the values that we discussed and value of drop rates to be displayed on bubble mouse over.

I believe i made a minor mistake which could be rectified quickly.

Thanks for your constant help.

Re: Google Maps - LA

Thu, 02 Jan 2014 11:14:00 GMT

any help ?

Re: Google Maps - LA

sujeetsingh — Thu, 02 Jan 2014 11:35:09 GMT

See the sample in that thread and go though it it will provide you some helpful fact .

Re: Google Maps - LA

sujeetsingh — Thu, 02 Jan 2014 11:36:51 GMT

Use longitude & latitude in dimension and then only the expression as SUm()

make sure that the linked longitude and latiude are correct .

Re: Google Maps - LA

Thu, 02 Jan 2014 12:57:34 GMT

Post doing that i am getting too few expressions.

Re: Google Maps - LA

Thu, 02 Jan 2014 13:49:00 GMT

Experts please help...

Below are teh problems:

- Drop rates values are not getting displayed

- Bubble size/color is not chnaging based on the value

Re: Google Maps - LA

Thu, 02 Jan 2014 20:48:12 GMT

To display a value as a pop up, you need to add a new expression and select the "text as pop-up" option. Something like this should suffice:

'Drop Rate: ' & Sum([Drop Rate])

As for the marker size, typically the expression that defines the marker size should be the 3rd expression in the listing (Long, Lat, Value).

Good luck.