GeoAnalytics: How to deal with city name with different names Spelling

[Joseph_Musekura]

In GeoAnalytics, the Map object is based on OpenStreetMap data (see OpenStreetMap copyright). Thus, when using "Map Object", due to name spelling miss-matches, different naming etc..., you may encounter an unexpected behavior when viewing cities, countries etc.. 

• A City's name is spelled in different ways

1. Pékin  instead of Beijing
2. Saint Louis instead of Saint-Louis or St. Louis
3. etc...

• Qlik GeoAnalytics includes alias for many cities but not all them. To correct the name's spelling, use one of below alternatives

1. Correct the city name in the source data (not always possible).
2. If you are using map extension, use the Layer's properties: Location Options->Manual Remap (for just a limited number of corrections to do)
   
3. Create a translation table that holds the different spellings: use the "mapping" prefix or the "map ...using" statement (mapping features provided both in  Qlik Sense and Qlikview). 

// remove the code (CCode) and replace by correct name of country
// When using map, the name of country (as found in http://www.geonames.org/) //will be used instead of Ccode 
mapCode:
mapping LOAD * Inline [
CCode, Country
Swe, Sweden
Dk, Denmark
No, Norway
] ;
// mapping CCode  to country
// If the country code is not in the mapping table, other country
Salespersons:
LOAD *, 
ApplyMap('mapCode', CCode,'other country') As Country 
Inline [
CCode, Salesperson 
Swe, John
Swe, Mary
Swe, Per 
Dk, Preben
Dk, Olle
No, Ole 
Sf, Risttu] ;
// AS we don't need the CCode anymore
Drop Field 'CCode';

Environment

• Qlik Sense Enterprise on Windows 
• Qlik GeoAnalytics 
• QlikView 

Related articles 

1. City names are not recognized by Qlik Sense
2. How to improve the lookup accuracy