2 Replies Latest reply: Apr 5, 2012 9:33 AM by Mike Lombard RSS

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