Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Google map issue

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!

1 Solution

Accepted Solutions
Not applicable
Author

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.

View solution in original post

14 Replies
IAMDV
Master II
Master II

Hi,

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

http://qlikshare.com/284

Cheers,

DV

www.QlikShare.com

Not applicable
Author

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

suniljain
Master
Master

please check latitude and longitude .

suniljain
Master
Master

please check latitude and longitude .

Not applicable
Author

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".  

Not applicable
Author

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..

BR

Hans

Not applicable
Author

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.

Not applicable
Author

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.

Not applicable
Author

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.