Google maps initialization script

Mon, 18 Nov 2013 14:57:21 GMT

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
];

Re: Google maps initialization script

Nicole-Smith — Tue, 19 Nov 2013 19:58:35 GMT

You need to get a map key from Google.

Google Maps stopped working

Re: Google maps initialization script

Bill_Britt — Tue, 19 Nov 2013 20:05:05 GMT

Hi Boris,

Check out this post.

Google Maps stopped working

Bill

Re: Google maps initialization script

Sun, 24 Nov 2013 07:04:03 GMT

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

Re: Google maps initialization script

shree909 — Tue, 03 Dec 2013 17:47:31 GMT

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

topic Re: Google maps initialization script in QlikView

Google maps initialization script

Re: Google maps initialization script

Re: Google maps initialization script

Re: Google maps initialization script

Re: Google maps initialization script