Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

fabricecallegar
Contributor

Longitude and latitude to an area (KML)

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

Tags (1)
15 Replies
micheledenardi
Valued Contributor

Re: Longitude and latitude to an area (KML)

Yes,

look at GeoMakePoint funcion.

ogster1974
Honored Contributor II

Re: Longitude and latitude to an area (KML)

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
Contributor

Re: Longitude and latitude to an area (KML)

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

ahaahaaha
Honored Contributor

Re: Longitude and latitude to an area (KML)

ahaahaaha
Honored Contributor

Re: Longitude and latitude to an area (KML)

Hi Fabrice,

May be like this

Source data (Uploaded KML file)

1.jpg

Script code

LOAD

    [.Name] as Name,

    [.Area] as AreaPolygon

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


Regards,

Andrey

ogster1974
Honored Contributor II

Re: Longitude and latitude to an area (KML)

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

ogster1974
Honored Contributor II

Re: Longitude and latitude to an area (KML)

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
Honored Contributor

Re: Longitude and latitude to an area (KML)

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
Honored Contributor II

Re: Longitude and latitude to an area (KML)

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