Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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