8 Replies Latest reply: Dec 18, 2017 10:58 AM by youssef belloum RSS

    Geo Coding in the Editor

    Philipp Sauren

      Dear All,

       

      I'm aware of the inbulid functionality of geo data mapping with ISO codes, city or country names when I add the data via the data manager. But how does it work when I load my data via the editor? How can refere to the existing geodata and link my cities and countries to the data?

      E.g. I'm loading data via the SAP connector and the edior and I would like to assign geo data to my data.

       

      Any idea/suggestion how to handle this?

       

      Thanks and regards,

       

      Philipp

        • Re: Geo Coding in the Editor
          Shahbaz Khan Mohammed

          It depends how your data looks like for geo map.

          Qlik Sense has by default 2 options to create a map.

          1. Latitude and Longitude (tagged to your Country/State/City etc)

          2. Polygon (KML or CSV files)

           

          SVG extension supports 2 or 3 digit ISO code for Country, State, City etc

          Google Map takes Latitude/Longitude/KML files as well

           

          Your data should have link between either country/state/city names to Latitude, longitude or KML data.

           

          For Latitude Longitude geomapping

          ex:

          Data:

          Load

          State,

          City,

          Sales,

          Population,

          SalesPerson,

          Latitude,

          Longitude,

          Geomakepoint(Latitude,Longitude) as GeoPoint

          From

          .....

           

          For KML or other ISO codes you do not have to write any extra script, just load the data as is and SVG would take it

          But if only tagging it with lat/long use

          Geomakepoint(Latitude,Longitude) as GeoPoint.


          PFA for your reference.