Solved: How to change zoom levels in Google Map? - Qlik Community

Report Inappropriate Content · ‎2011-08-16

I am currently using a Google map scatter chart, but my data points are plotting to a different zoom level.

The red should completly overlay the US. How do I change the zoom levels so this is correct?

Report Inappropriate Content · ‎2011-08-16

Well I just got it working. apparently it wants to be set to size 400, even if the actuall chart is not that size.

I changed the def_map_size to 400 and map_size_x and map_size_y to 400 and it is working fine.

I would have thought it would need the map sizes set to the actuall size of the chart but I guess not. Thank you everyone for your help.

View solution in original post

rbecher · ‎2011-08-16

Hi,

there is probably an error in your axes formulas. Can you post some example?

- Ralf

Astrato.io Head of R&D

Report Inappropriate Content · ‎2011-08-16

X Axis:

Static Min: =(256*pow(2,($(var_zoom)-1)))+( var_mid_long *((256*pow(2,$(var_zoom)))/360)) -round(map_size_x/2)

Static Max: =((256*pow(2,($(var_zoom)-1)))+( var_mid_long *((256*pow(2,$(var_zoom)))/360)) + round(map_size_x/2))

Y Axis:

Static Min: =((256*pow(2,($(var_zoom)-1)))+((0.5*log((1+(sin(var_mid_lat*pi()/180)))/(1-(sin(var_mid_lat*pi()/180)))))*((-256*pow(2,$(var_zoom)))/(2*pi())))+round(map_size_y/2))

Static Max: =((256*pow(2,($(var_zoom)-1)))+((0.5*log((1+(sin(var_mid_lat*pi()/180)))/(1-(sin(var_mid_lat*pi()/180)))))*((-256*pow(2,$(var_zoom)))/(2*pi())))-round(map_size_y/2))

Longitude:

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

Latitude:

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

(sin((Latitude)*pi()/180)))))*((-256*pow(2,$(var_zoom)))/(2*pi()))))

Report Inappropriate Content · ‎2011-08-16

try where says max_zoom_Leel = # (Could be from 1 to 17)

Report Inappropriate Content · ‎2011-08-16

Do you mean on the script?

This is my script for the map

//// Google Maps Key
//// get a key here http://code.google.com/apis/maps/signup.html
//gmap_key = 'xx'; 
max_zoom_level = 17; //maximum value 17
def_zoom_level = 1;
def_map_size = 757;
//// Variables required for calculating map
//// No need to change these
var_pi180= '=pi()/180';
var_lat_offset= '0';
var_long_offset= '0';
var_mc2= '=256*pow(2,$(var_zoom))';
var_mc1= '=256*pow(2,($(var_zoom)-1))';
var_mid_lat= '=median(Latitude)';
var_mid_long= '=median(Longitude)';
var_zoom= '=If(max(aggr(if(max( round(256*pow(2,(_zoom_level -1)))+( Longitude *((256*pow(2,_zoom_level
))/360)) )-min( round(256*pow(2,(_zoom_level -1)))+( Longitude *((256*pow(2,_zoom_level ))/360)) )
<def_map_size AND max((256*pow(2,(_zoom_level-1)))+((0.5*log((1+(sin((Latitude)*pi()/180)))/(1-
(sin((Latitude)*pi()/180)))))*((-256*pow(2,_zoom_level))/(2*pi()))))-min((256*pow(2,(_zoom_level-
1)))+((0.5*log((1+(sin((Latitude)*pi()/180)))/(1-(sin((Latitude)*pi()/180)))))*((-
256*pow(2,_zoom_level))/(2*pi()))))<def_map_size,_zoom_level,null()),_zoom_level))>def_zoom_level,
max(aggr(if(max( round(256*pow(2,(_zoom_level -1)))+( Longitude *((256*pow(2,_zoom_level ))/360)) )-min(
round(256*pow(2,(_zoom_level -1)))+( Longitude *((256*pow(2,_zoom_level ))/360)) ) <def_map_size AND
max((256*pow(2,(_zoom_level-1)))+((0.5*log((1+(sin((Latitude)*pi()/180)))/(1-(sin((Latitude)*pi()/180)))))*((-
256*pow(2,_zoom_level))/(2*pi()))))-min((256*pow(2,(_zoom_level-
1)))+((0.5*log((1+(sin((Latitude)*pi()/180)))/(1-(sin((Latitude)*pi()/180)))))*((-
256*pow(2,_zoom_level))/(2*pi()))))<def_map_size,_zoom_level,null()),_zoom_level)),def_zoom_level)';
var_maptype= '=if(isnull(only(maptype)),fieldvalue( '&chr(39)&'maptype'&chr(39)&', 4 ),maptype)';
//// Field required for calcualting best zoom level
SET HidePrefix='_' ;
_zoom_level:
Load RecNo( ) as _zoom_level autogenerate(max_zoom_level);
maptype:
LOAD * INLINE [
Maptype
roadmap
mobile
satellite
terrain
hybrid
];

rbecher · ‎2011-08-16

please also list all variables...

Astrato.io Head of R&D

rbecher · ‎2011-08-16

map_size_x

map_size_y

?

Astrato.io Head of R&D

Report Inappropriate Content · ‎2011-08-16

max_zoom_level = 17 def_zoom_level = 1 def_map_size = 757 var_pi180= '=pi()/180' var_lat_offset= '0' var_long_offset= '0' var_mc2= '=256*pow(2,$(var_zoom))' var_mc1= '=256*pow(2,($(var_zoom)-1))' var_mid_lat= '=median(Latitude)' var_mid_long= '=median(Longitude)' var_zoom= '=If(max(aggr(if(max( round(256*pow(2,(_zoom_level -1)))+( Longitude *((256*pow(2,_zoom_level ))/360)) )-min( round(256*pow(2,(_zoom_level -1)))+( Longitude *((256*pow(2,_zoom_level ))/360)) ) <def_map_size AND max((256*pow(2,(_zoom_level-1)))+((0.5*log((1+(sin((Latitude)*pi()/180)))/(1- (sin((Latitude)*pi()/180)))))*((-256*pow(2,_zoom_level))/(2*pi()))))-min((256*pow(2,(_zoom_level- 1)))+((0.5*log((1+(sin((Latitude)*pi()/180)))/(1-(sin((Latitude)*pi()/180)))))*((- 256*pow(2,_zoom_level))/(2*pi()))))<def_map_size,_zoom_level,null()),_zoom_level))>def_zoom_level, max(aggr(if(max( round(256*pow(2,(_zoom_level -1)))+( Longitude *((256*pow(2,_zoom_level ))/360)) )-min( round(256*pow(2,(_zoom_level -1)))+( Longitude *((256*pow(2,_zoom_level ))/360)) ) <def_map_size AND max((256*pow(2,(_zoom_level-1)))+((0.5*log((1+(sin((Latitude)*pi()/180)))/(1-(sin((Latitude)*pi()/180)))))*((- 256*pow(2,_zoom_level))/(2*pi()))))-min((256*pow(2,(_zoom_level- 1)))+((0.5*log((1+(sin((Latitude)*pi()/180)))/(1-(sin((Latitude)*pi()/180)))))*((- 256*pow(2,_zoom_level))/(2*pi()))))<def_map_size,_zoom_level,null()),_zoom_level)),def_zoom_level)'; var_maptype= '=if(isnull(only(maptype)),fieldvalue( '&chr(39)&'maptype'&chr(39)&', 4 ),maptype)'

Report Inappropriate Content · ‎2011-08-16

Doble check in the variables that Latitude and Longitude is wrote correctly, just like your latitude and longitude Table. Is it wrot correctly?

Report Inappropriate Content · ‎2011-08-16

Yes, they are all set to Latitude, and Longitude