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 maps initialization script

Hi all,

I found this script in older Forums and it doesn't work giving all kinds of errors.

I'm using QlikView 11 version.

does anyone have the correct script?

Thanks,

Boris

// Google Maps in QlikView
// V0.85.2 – October 1st 2008  © Copyright QlikTech International AB 2008 / AES

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

// Variables required for calculating map
// No need to change these
var_pi180=           ‘=pi()/180′;
var_lat_offset=      ’0′;
var_mc2=             ‘=256*pow(2,$(var_zoom))’;
var_mc1=             ‘=256*pow(2,($(var_zoom)-1))’;
var_mid_lat=  ‘=min(latitude)+(1+var_lat_offset)*((max(latitude)-min(latitude))/2)’;
var_mid_long= ‘=min(longitude)+(max(longitude)-min(longitude))/2′;
var_zoom=            ‘=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)) ) <map_size_x 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()))))<map_size_y,_zoom_level,1),_zoom_level))’;
var_maptype=  ‘=if(isnull(only(maptype)),fieldvalue( ‘&chr(39)&’maptype’&chr(39)&’, 1 ),maptype)’;
map_size_x=       ’400′;
map_size_y=     ’400′;

SET HidePrefix=’_’ ;
// Field required for calcualting best zoom level
_zoom_level:
Load RecNo( ) as _zoom_level autogenerate(max_zoom_level);

maptype:
LOAD * INLINE [
maptype
roadmap
mobile
satellite
terrain
hybrid
];

2 Replies
Not applicable
Author

Hi,

If you are trying to use Google Maps extension in Qlikview, Please install Qlikview Version 11.2 and then there  are a no of extension .qar files which you can install and add your maps as extension objects.

Not applicable
Author

I'm already using 11.2