5 Replies Latest reply: Jun 13, 2012 8:52 AM by David Gangarossa RSS

    Google Map Keeps Vanishing

      I am having a really strange issue when overlaying a scatter on Google maps. On saving and reopening the app the dynamic image in this case the map keeps dropping out and seems to only come back after closing the Qlikview application leaving it for an extended period of time and then reopening (although this is still a bit hit and miss).

       

      The version of Qlikview being used is Qlikview 10 r2

       

      And the approach being taken in the script is:

       

      // Google Maps Key
      // get a key here http://code.google.com/apis/maps/signup.htmlgmap_key = 'xx';max_zoom_level = 12; //maximum value 17 // Variables required for calculating map
      // No need to change thesevar_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=         '530';map_size_y=     '450';
      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
      ]
      ;

       

       

      And the syntax in the dynamic image  is...

       

      ='http://maps.google.com/staticmap?center='
      &num(var_mid_lat, '##############', '.', ',' )
      &
      ','
      &num(var_mid_long, '##############', '.', ',' )
      &
      '&zoom=$(var_zoom)'
      &
      '&maptype='&
      var_maptype
      &
      '&size='&
      map_size_x&'x'&map_size_y
      &
      '&key='&
      gmap_key & '.jpg'

       

      I would appreciate any ideas how to stabilise this component of the app.

       

      Regards

       

      Kris


        • Google Map Keeps Vanishing

          Open the example in the QlikView folder and copy/paste the script stuff and the dynamic imagine syntax.  I have no clue if your's is right or not but as far as I know there's no reason to change any of that.  Assuming everything is the same... I thought I read something about maps in v10 being different but since I have v9 so I don't have a clue.

           

          Sorry I couldn't be more useful

          • Re: Google Map Keeps Vanishing
            David Gangarossa

            Hi All,

             

            GIS/Maps Analytics in QlikView is a very interesting topic indeed.

             

            However, there are many technical limitations in using Google Maps (GMaps) to display QlikView KPI indicators. First of all, the drill-down, pan and selection capabilities are quite limited. Moreover, you cannot display several indicators at the same time and on the same map (background + foreground indicators), you are also limited to draw bubbles and therefore you cannot display pie/bar charts nor "real" heat maps. Finally, you cannot display QlikView KPIs on specific Sales/Business Areas with GMaps such as the Bricks in the Pharmaceutical sector (Brick = aggregation of zipcodes).

             

            On top of that, there are also a few "commercial" aspects to be considered since many QlikView customers & channel partners use GMaps API "FREE" Key inside their QlikView server or rich client without complying with GMaps license terms...Indeed, for "professional internal use" (intranet, extranet or internet with username/password authentication to QlikView application), you must buy GMaps API "Premier" which costs about 10,000 $ USD per year or 8,500 euros per year + possible extra fees depending upon the total number of daily hits.

             

            A few alternatives exist such as Open Street Map (totally FREE) or other WMS/TMS services. I hereby suggest you to have a look at our new mapping extension for QlikView 11 SR1 namely "GeoQlik v11.6":

            http://www.geoqlik.com/en/geoqlik-for-qlikview/geoqlik-v11.html

             

            Please find hereafter a few screenshots of GeoQlik V11.6 using WMS/TMS services to display QlikView KPIs:

            geoqlik_v11_demo_1.JPG

            geoqlik_v11_demo_2.JPG

            geoqlik_v11_demo_3.JPG

            geoqlik_v11_full.jpg

            Thanks and best regards,

             

            David

            @ Business Geografic