Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
];
You need to get a map key from Google.
Hi Boris,
Check out this post.
Bill
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
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..