Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with Google maps in Developer

I am trying to use google maps in QlikView V10 but the graphic of the map is not displaying. The points on the US map are being shown based on the data selected but the actual map image is not rendering.
The Image is attached showing the results:



// Google Maps in QlikView
// V0.85 - 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 = 'ABQIAAAAJPUVFBu7AqNG1HJ1AMIYlRS8L2znXsmj_Cq36ZaGV79Wrtx6FxTRcqV5kJv84RTneMvpH_AZZqpSaA';
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)) ) <400 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()))))<400,_zoom_level,null()),_zoom_level))';
var_maptype =     '=if(isnull(only(maptype)),fieldvalue( '&chr(39)&'maptype'&chr(39)&', 1 ),maptype)';

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

Accepted Solutions
Not applicable
Author

The problem was corrected by adjusting the value to 0% on the transparent value on the color tab !  Apparently the default value is 100% blocking the image from being dispalyed....

View solution in original post

2 Replies
jvitantonio
Luminary Alumni
Luminary Alumni

Hi, go to the chart properties. Go to the Color tab, do you have the Dynamic image setup?

='http://maps.google.com/staticmap?center='&Replace(var_mid_lat,',','.')&','&Replace(var_mid_long,',',...'

Not applicable
Author

The problem was corrected by adjusting the value to 0% on the transparent value on the color tab !  Apparently the default value is 100% blocking the image from being dispalyed....