2 Replies Latest reply: Sep 26, 2013 10:39 AM by Stefan Truniger RSS

    Best Qlikview extension to display information on maps

      Hi to all,

       

      I am assigned by my company to create a Qlikview Application that among other things, it will display the information of our customers in google maps (not necessary, any kind of maps will do). My data are in qvd files and contain the information of our customers, along with their demographic information (Address,city , Zip Code etc). The addresses are in Greek (since we are a Greek company with customers all over Greece). We do not have any latitude or longitude information available for our customers addresses.

       

      The way i want to display the map with the information is just like in Google maps. A pin will be placed at the Customer address and by selecting the pin the user can filter the data fro this customer like a normal selection box.

       

      I have seen extentions like Geoqlik but i do not know how they work exactly in getting the precise location of the address in the map. Especially i am interested to know if the greek characters in the Customer address (since it the only actual data that we have) can be used to create the maps we want.

       

      Thank you all in advance.

        • Re: Best Qlikview extension to display information on maps
          Jérémy George

          The latest geoqlik version allows you to display information on a map from longitude/latitude or from postal addresses included in your qlikview document. Geocoding is done with openstreet map data or with google if you provide your google key. Greek characters in addresses are not a problem since GeoQlik supports unicode.

          Unfortunately the trial version of geoqlik does not provide the address geocoding but I suggest you to contact business geografic to ask them for a demo with your own data.

          • Re: Best Qlikview extension to display information on maps
            Stefan Truniger

            With a bit of effort you can get the longitude and lattitude from Google as well.

             

            I did the following:

             

            (1) Create a table with all your customer addresses (in my example the table Addresses)

            (2) Have on field with the full address as required by the Google API [Street,+ZIP,+Town,+Country]

            (3) Loop through all these addresses using the following script:

             

            for i=0 to $(noRows)

                let b = peek('FullAddress',$(i),'Addresses');

                  

                GeocodeResponse:

                LOAD

                status,

                '$(b)' as FullAddress,

                ([result/geometry/location/lat]) as Latitude,

                ([result/geometry/location/lng]) as Longitude

                FROM [http://maps.googleapis.com/maps/api/geocode/xml?address=$(b)&sensor=false] (XmlSimple, Table is [GeocodeResponse]);

                sleep 60;

            next i;

             

            I have added a sleep statement to the loop in order not to bomb Google.

            Be sure to check out the Google API's terms of use though: https://developers.google.com/terms/

             

            Once you have all the Longitude / Latitude information I think you can fulfill your requirements with the standard Google Maps solution, or, alternatively with some of the free extensions posted here on the forum:

            http://community.qlik.com/message/325641#325641