Calculate district/country with GeoAnalytics operation

[pwagner]

Hello,

I have following situation:

We addresses in our customer-masterdate. With GeoCoding I have got the coordinates for these addresses.

Now I need the district/counties for these addresses as well. Unfortunately I cannot find the correct way how to 'calculate' the districts/counties out of the coordinates.

Has someone an idea how to solve that? Which  GeoAnalytics operation is the right one?

@Patric_Nordstrom  could you help me in this topic?

Thank you.

Best regards, Patrick

[Patric_Nordstrom]

The Qlik Geocoding, specifically the AddressPointLookup function returns adm1 code which is normally the state or the county.

https://help.qlik.com/en-US/geoanalytics/Subsystems/GeoConnector/Content/connector/connector-geoanal...

There is a NamedPointLookup function which you can use to get adm 1 and adm 2 for a city name:

https://help.qlik.com/en-US/geoanalytics/Subsystems/GeoConnector/Content/connector/connector-geoanal...

Thanks,

Patric

[pwagner]

Hello Patric,

thank you for your advice.

Unfortunately I have with 'NamedPointLookup' same troubles like a posted here:

https://community.qlik.com/t5/Qlik-GeoAnalytics-Discussions/GeoOperations-problem-quot-Can-not-conve...

This is the errorcode:

Error occured
bei IdevioGeoAnalyticsConnector.Utils.executeRequest(String url, String postData, String operation, Boolean useDefaultUrl)
bei IdevioGeoAnalyticsConnector.SelectFieldsPanel..ctor(Dictionary`2 parameters, Dictionary`2 datasetParameters, String serverUrl)
bei IdevioGeoAnalyticsConnector.SelectDialog.showNext()

Do you have an idea how to solve this problem?

[Patric_Nordstrom]

Ok, the NamedPointLookup needs a location string like a city name plus country as input.

Point or lat long cant be used 

Thanks

Patric 

[pwagner]

This location string should already exists in the loaded table?

If you or someone of Qlik can provide a screenshot like a posted before with example data, this would be great. Then it is easier to understand how to work with the operations.

[Patric_Nordstrom · Accepted solution]

Here's examples for all the connector operations:

https://community.qlik.com/t5/Qlik-GeoAnalytics-Documents/Connector-Examples-Qlik-GeoAnalytics/ta-p/...

Thanks,

Patric

[pwagner]

Perfect, thank you for your advice.

Best regards, Patrick