Matching location names with those used in the map object

oknotsen — Fri, 13 Aug 2021 13:08:03 GMT

I have a list of retailers I want to plot on a map. The map is limited to the Netherlands (so 'NL'). However, when I ask the map object to plot all my cities on the map using an area layer, a lot of them are not found.

Clicking on that "i" symbol when editing the object indeed tells me (for example) "Location not found: Sneek,NL". Which is funny, because at the same moment the map object itself is showing "Sneek". And yes, I did check for leading or trailing spaces. According to the len() function, the text in this example is 5 characters.

Now there must be some sort of weird matching going wrong, so I wonder if there is a way to get the list of all cities this map object in Qlik uses so I can check what spelling or whatever other data mismatch there is.

Also open for other suggestions on how to fix this.

topic Matching location names with those used in the map object in Connectivity & Data Prep

Matching location names with those used in the map object