City / County and State Confusion in Map Visualization

Gui_Approbato — Thu, 29 Aug 2019 19:29:31 GMT

Hello,

Using Qlik Sense Desktop I've been exploring some datasets with City and State names for US and Brazil.

In the script I created a "City, State" field which is used in the Map, with the Country code.

In most states I can see every city or county, except for those in which the city/county name is the same as of the state's.

Example: São Paulo, SP (the city and state have the same name) or Iowa, IA .

The map gets messy and the only solution I found was to exclude these cases from the map.

Does anybody know how to solve this issue?

Two simple examples below, just to make it clear:

topic City / County and State Confusion in Map Visualization in App Development