When dealing with GeoAnalytics, in most cases, using a field as location could have limitations.
For example:
- Each place name has several aliases for the same location (see solution here)
- A place name can be, at the same time, used as a name for City, District, Region etc...
As solution to the second alternative is discussed in below link
https://community.qlik.com/t5/Qlik-GeoAnalytics-Documents/How-to-improve-the-lookup-accuracy/ta-p/1553461This solution is based on the following logic
-----------------
When the database is queried it responds back with a geometry. Most of entries are points but the database also contains many area geometries for well-known regions. The database also keeps a hierarchy of the entries, a place belongs to country and a region, in order to distinguish places from each other.-----------------
So, providing location details, as defined below, will allow GeoAnalytics to apply the hierarchy found in the database entries and thus differentiate a place from each other, a City name to County name (in case they are the same), a County to State, a State to Country....
Example:=city & if(len(county)>0, ',' & county) & if(len(state)>0, ',' & state) & if(len(country)>0, ',' & country) & ':P*'
Environment
- Qlik GeoAnalytics (all versions)