Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
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
];

4 Replies
Nicole-Smith

You need to get a map key from Google.

Google Maps stopped working

Bill_Britt
Former Employee
Former Employee

Hi Boris,

Check out this post.

Google Maps stopped working

Bill

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
Not applicable
Author

In google it says that no key is needed fot the maps API.

Sign Up for the Google Maps API - Google Maps API — Google Developers

shree909
Partner - Specialist II
Partner - Specialist II

Hi Bill,

How to get the Google Maps API Key for Business.

when i signup for business it asks to use the client id for the Static image map.

in the development i am suing the api key with personal google gmail account.

what exactyly this key is called in business..