3 Replies Latest reply: Feb 1, 2017 2:07 PM by Michael Tarallo RSS

    Geo Analytics using lat and Longitude

    Goutham Kandukuri

      Hi,

      I have a file with Latitude and longitude information but no cities or countries.

      How can i use this information to map Idevio Maps(Geo Analytics Extension)

       

      Please Advise.

        • Re: Geo Analytics using lat and Longitude
          Michael Tarallo

          Hello Goutham,

           

          Thanks for your question, it depends on the format of the coordinates.

           

          Qlik GeoAnalytics reads them in as Longitude and Latitude and this data can be in different forms. They could be separate columns like Long, Lat - it can be a point such as [Long,Lat]. Geo Analytics gives you a few options for the how you want to define the points in the layers.

           

          I will have a video on this shortly, but please see the attached an example for you.

           

          When you open the app, look at the inline data in the Data Load Editor.

           

          Example 1:

           

          [table1]:
          LOAD * Inline "
          id,start,dest,startname,destname
          1,'[-73.969956,40.784690]','[-73.961791,40.776162]',home,gmas
          ";
          

           

          Using 2 Bubble Layers - each with one point - and Location options are set to Auto or Dimension:

           

           

           

          Example 2:

           

          [table2]:
          LOAD * Inline "
          Tid2,long,lat,name
          1,-73.969956,40.784690,start
          2,-73.961791,40.776162,end
          ";
          

           

          Using one Bubble Layer and setting the Location Options setting to use Latitude,Longitude

           

           

           

          Example 3:

           

          If you have separate Lat and Long like in Table2, you could also create a point coordinate by concatenating the Longitude and Latitude like this ='['&long&','&lat&']' and using it in the dimension of the layer:

           

           

          Hope this gives you a few key points on how you can use.

           

          See the sample attached.

           

          If using Qlik Sense Desktop please copy .qvf file to your C:\Users\<user profile>\Documents\Qlik\Sense\Apps and refresh Qlik Sense Desktop with F5. If using Qlik Sense Enterprise Server please import .qvf into your apps using the QMC - Qlik Management Console.

           

          When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

           

          Regards,

           

          Michael Tarallo (@mtarallo) | Twitter

          Qlik