Matching geo-points with area

[Anonymous]

I have a dataset with geo-points (lat/long) across the world and KML-file with country boundaries. Is it possible to aggregate points by countries? And how to match points with area using QlikSense?

Source data:

Measure	Lat	Long
100	32	54
150	40	50
200	43	70
...	...	...

KML-file

Country Code	Area
USA	[...]
ITA	[...]
...	[...]

Desired result:

[#2]

Hi,

I believe you need to do a reverse geocoding. There is a solution that you can pick up here: http://community.qlik.com/message/300636#300636

If you use rperezlaso solution for your source data and append country (provided by this line MaxString(if(Address_Type = 'country' , Value)) as Country  ) then you can link it to your KML by the country field.

I haven't tried this solution but it may be work for you.

Kind regards,

Nuno