topic Re: Geo Analytics using lat and Longitude in GeoAnalytics

Geo Analytics using lat and Longitude

gouthamkk — Tue, 31 Jan 2017 21:14:56 GMT

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 — Wed, 01 Feb 2017 00:14:29 GMT

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

Re: Geo Analytics using lat and Longitude

gouthamkk — Wed, 01 Feb 2017 18:45:46 GMT

Thank you, examples are very helpful

Re: Geo Analytics using lat and Longitude

Michael_Tarallo — Wed, 01 Feb 2017 19:07:54 GMT

Awesome - I just published the video as well:

Qlik GeoAnalytics - Latitude and Longitude Tips

Re: Geo Analytics using lat and Longitude

detmawin — Tue, 15 May 2018 06:14:08 GMT

Can you use this in an area layer as well?

Thank you for the awesome information.

Re: Geo Analytics using lat and Longitude

Michael_Tarallo — Tue, 15 May 2018 13:56:18 GMT

Hi Mai - thanks for your question - I am not sure - I will see if bps‌ can assist - are you asking if you can use individual Lat and Long from a data source to create the area layer? - or to plot the points on an area layer as well?

Re: Geo Analytics using lat and Longitude

detmawin — Tue, 15 May 2018 14:13:17 GMT

Also I previously used the KML map and area that mapped the zip codes, county and cities in florida perfectly, is there any way I can use the KML area dimension in the area layer to avoid the lookup issues.

Thanks very much.

Re: Geo Analytics using lat and Longitude

Patric_Nordstrom — Wed, 16 May 2018 14:18:28 GMT

Hi Mai,

Yes, you can use the KML areas in the QGA map if you want.

I recommend add the KML area field as the "Location ID" measure.

Thanks,

Patric