There are two Geo Analytics operations you can use, one for checking areas and one for checking points:
- NamedAreaLookup – Get the polygons for named areas such as countries, administrative areas and postal areas.
- NamedPointLookup – Get the (center)points for named areas such as countries, administrative areas and postal areas.
You will get a resulting a table with the matching records so you can find and correct the bad ones.
When supplying info to the lookup, you can improve the results by providing additional location and type information. See the documentation for more info about the location service. here's two example how to refer to cities and postal codes (XPC indicates xip info and P* is place info).
=city:name & ',' state_abbr & ',US:P*'
=zip_code & ',US:XPC'
Another good op is the "Load" operation, you can for instance load all the counties in the us to check the spelling of the county name.
Links to doc:
I downloaded the Qlik Sense app and installed and licensed Qlik GA for Sense.
I downloaded the AddressPointLookup Example
I can open the app in Qlik Sense and it shows the validated map OK.
When I reload the document, I get this error:
The following error occurred:
Connector reply error: QVX_SYNTAX_ERROR: The GeoCode server responded with error: 403, Forbidden
The error occurred here:
Data has not been loaded. Please correct the error and try loading again.
The GA connector is set to use the GeoAnalytics server https://ga.qlikcloud.com and the connection tests successfully.
Thanks in advance,