Longitude and latitude to an area (KML)

[fabricecallegar]

Hello,

I use Qlik Sense.

I have data with longitude and latitude and I want to associate these points to areas come from a KML file.

Is it possible to do that ?

Is there a function to know in witch area belong a point ?

Thank for your help

Fabrice

[micheledenardi]

Yes,

look at GeoMakePoint funcion.

[ogster1974]

I'm doing the same thing.  I have my areas in kml file but the location data I have doesn't contain post codes or longitude/latitude data. so I have joined my data on name of the area.

Is there a function to find the center point of an area to back fill this missing content?

[fabricecallegar]

Thank Michele, but how can I do to associate this coordinates to an area ?

[ahaahaaha]

Hi,

May be GeoGetPolygonCenter - script and chart function ‒ Qlik Sense

[ahaahaaha]

Hi Fabrice,

May be like this

Source data (Uploaded KML file)

Script code

LOAD

    [.Name] as Name,

    [.Area] as AreaPolygon

FROM [lib:// [Path your KML file])

Regards,

Andrey

[ogster1974]

I'd just seen that function Andrey i'm going to give it a whirl

[ogster1974]

I have a KML file that contains Area and now point data.

when I drop the area field data onto the map it looks like this.  Boundaries mapped perfectly,

When I link it to my location data the map seems to lose this understanding of where in the world it is and the area layer returns unsuccessful matching and displays a blank map.  Any ideas what can be causing it?

I think I need to be disabling the geographical sevice but not sure what to put in its place.

Regards

Andy

[ahaahaaha]

Hi Andy,

In the attached file, a sample of maps with a layer of area and a layer of points. The source KML file itself suggested splitting the entire area into districts. Therefore, each point represents the center of the district. If you do selections by points, then it will be clearly visible.

Regards,

Andrey

[ogster1974]

Currently I'm looking at ways to reduce the size of my KML file.  this seems to be the issue.