topic Re: Google map issue in QlikView

Google map issue

Thu, 12 Jul 2012 09:07:24 GMT

Hi,

I´m trying to use google maps to my application. The map looks good but I doesn´t succed to point out the customers on the map, they doesn't appears in diffrent bubble sizes when I count them for specific cities. See attached example. Any one that have a solution for my issue?

Thanks in advance!

Re: Google map issue

IAMDV — Mon, 13 Aug 2012 10:57:16 GMT

Hi,

I have created this video tutorial on using Google Maps as Extension Object. Please check the below link...

http://qlikshare.com/284

Cheers,

www.QlikShare.com

Re: Google map issue

Mon, 13 Aug 2012 12:02:57 GMT

Thanks for reply. Unfortunately it´s not helping to solve my issue.

Re: Google map issue

suniljain — Mon, 13 Aug 2012 12:04:30 GMT

please check latitude and longitude .

Re: Google map issue

suniljain — Mon, 13 Aug 2012 12:04:39 GMT

please check latitude and longitude .

Re: Google map issue

Mon, 13 Aug 2012 12:21:21 GMT

What do you mean, is there something wrong with the coordinates?

That I can see the map is working when I change e.g city but it's not showning the numbers of customers for every city, displays "bubbles".

Re: Google map issue

Mon, 13 Aug 2012 13:46:08 GMT

Hi,

I would look at the datamodel contaning the coordintates once more.

If I select the City Falun and the longitude 15,63709 I have a frequency of 12 Longitudes...

What if you separate customer info from longitude and latitude.

Like you did for City... If you put PersonId into a own table connected to long, lat table connected to the long lat with a AdressID as Key..

Hans

Re: Google map issue

Mon, 13 Aug 2012 14:04:51 GMT

Bjorn:

Change the expressions as below:

Longitude:

round(256*pow(2,($(var_zoom)-1)))+Avg(Longitude)*(256*pow(2,$(var_zoom)))/360

Latitude:

256*pow(2,($(var_zoom)-1))+(0.5*log((1+(sin((Avg(Latitude))*pi()/180)))/(1-(sin((Avg(Latitude))*pi()/180)))))*((-256*pow(2,$(var_zoom)))/(2*pi()))

Kiran.

Re: Google map issue

Mon, 13 Aug 2012 14:26:29 GMT

Kiran, thanks a lot for your reply. It´s looking good now but I need to zoom one step to see anything/bubbles. Do you also have a solution for that? In your example it looks good without zoom.

Re: Google map issue

Mon, 13 Aug 2012 14:39:55 GMT

I didn't understand you question. I did zoom and it was wokring as expected. Do you want to hide the text in the maps?

Regards,

Kiran Rokkam.

Re: Google map issue

Mon, 13 Aug 2012 14:48:44 GMT

Sorry for bad explanation.

In your example I see all the bubbles without doing anything. But in my example I need to mark all the cities (or zoom the whole map) to get the same view as in your example. See attached pictures.

Re: Google map issue

Mon, 13 Aug 2012 14:52:19 GMT

Probably your bubbles are too small. Try changing the symbol size in presentation tab.

Regards,

Kiran Rokkam.

Re: Google map issue

Tue, 14 Aug 2012 07:59:08 GMT

Unfortunately it doesn't change anything. I've also tried to change the map_size in the script but without success. And if I just copy your sampel it doesn't change. Any more ideas?

Re: Google map issue

Tue, 14 Aug 2012 08:31:18 GMT

Can you share your application? Since its application specific issue I believe data is playing a huge role.

Thanks,

Kiran.

Re: Google map issue

Wed, 15 Aug 2012 10:46:41 GMT

I've solve the issue. The problem was that I was using a keyfield when counting the nr of customer.

Thanks a lot for your help Kiran.