3 Replies Latest reply: Jun 13, 2012 9:13 AM by David Gangarossa RSS

    How 2 add Google API chart Map in QV?

      Hi Guys,

       

      I don't have any experience with Javascript. Is there a simple document that describes how to add the Google API MAP chart in Qlikview.

      I've being looking at Rob's example, which looks really nice :). I want to apply that but for a different country. I don't know were to start nor where to set the parameter or choose the country/cities I would like to see.

       

      I've looked at this site: http://code.google.com/apis/ajax/playground/?type=visualization#geo_chart

       

      But can't really figure out where to add the country and cities I want to see and integrate it in QV.

       

      Thanks in advance!

       

      Carter

        • Re: How 2 add Google API chart Map in QV?
          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 Zones or Sales 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