# New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

## How to change zoom levels in Google Map?

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?

Tags (4)
1 Solution

Accepted Solutions
Not applicable

## Re: How to change zoom levels in Google Map?

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.

17 Replies
MVP & Luminary

## How to change zoom levels in Google Map?

Hi,

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

- Ralf

Not applicable

## Re: How to change zoom levels in Google Map?

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()))))

Not applicable

## How to change zoom levels in Google Map?

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

Not applicable

## Re: How to change zoom levels in Google Map?

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 17def_zoom_level = 1;def_map_size = 757;//// Variables required for calculating map//// No need to change thesevar_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 ANDmax((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 levelSET HidePrefix='_' ;_zoom_level:Load RecNo( ) as _zoom_level autogenerate(max_zoom_level);maptype:LOAD * INLINE [Maptyperoadmapmobilesatelliteterrainhybrid];`
MVP & Luminary

MVP & Luminary

map_size_x

map_size_y

?

Not applicable

## How to change zoom levels in Google Map?

`max_zoom_level = 17 def_zoom_level = 1def_map_size = 757var_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 ANDmax((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)'`

Not applicable

## How to change zoom levels in Google Map?

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

Not applicable

## How to change zoom levels in Google Map?

Yes, they are all set to Latitude, and Longitude