Mapping kml with GeoPoint

[WernerDC]

Hi guys.

Hope someone can help me.

I have a kml file with Provinces/Districts.

I also have a dataset with Lat&Long. I use GeoMakepoint to create a Point out of the Lat&Long.

How do I combine the 2?

My idea is to have the Area Layer(kml file) as the first layer on a Map then when I select the Province I can then see all the points (GeoPoint) in that layer. I would also like to use the area layer in a Filter pane so that I can limit the click on the Map.

This is the kml:

This is my other data:

See the Geopoint

Hope someone can help me.

Kind regards

[pedrobergo]

Hi @WernerDC 

Using Qlik Sense, you'll need to use GeoAnalytics function named WITHIN, it can be found at Qlik GA Connector Examples 

For SaaS, you need to use a built-in extension GeoOperation, WITHIN also, examples at GeoOperations Reference

This operation will return a table with the Area id (p1, p2, ...) and GeoPoint id wich you can use in your map or filtering.

[],

Pedro

[WernerDC]

Does this meen I need Qlik GeoAnalytics?

[pedrobergo]

Hi @WernerDC 

Yes.

Your kml file doesn't have an associated field with the "other data" file.

Area is a polygon, GeoPoint is a point.

So, you'll need to connect both tables to make selections reflects on each other. If you select 'p1',  Qlik cannot identify wich points has inside it, and it will show all GeoPoints.

The WITHIN function will create the connection between the tables, determining wich GeoPoint belongs to each Area. When you select 'p1', Qlik will show only the GeoPoints wich are both associated.

You can also use an external tool, like GoogleEarth, QGIS and others, but it is another history...

[],

Pedro