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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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.