Qlik Area Map Error When County Name=State Name

[zhbuyiqlik]

The following two figures are UTAH area maps by county.  UTAH happens to have a county called UTAH.   All counties after UTAH alphabetically are recognized by Qlik to be UTAH county, as shown in Figure 1.

I removed UTAH county from the data, and thus the "correct" as in figure 2.

How to show the are map correctly with UTAH county in?

Figure 1.  When included UTAH County in UTAH State area map.

Figure 2:  This is what should look like

[Steven_Haught]

@zhbuyiqlik 

You may need to concate  county and state in the dimension. You sometimes need to give more details for more accuracy. See below solution that is similar. Please also see Patric's write up on location accuracy. 

https://community.qlik.com/t5/GeoAnalytics/Area-layer-confused-on-multiple-same-name-counties/td-p/1...

Article:

https://community.qlik.com/t5/Documents/How-to-improve-the-lookup-accuracy/ta-p/1553461?_ga=2.489680...

[zhbuyiqlik]

@ Steve. 

Thank you for your reply.

I have already concat county and state in the dimension.   The issue is not the map is confused between counties with the same name.  The issue is that Qlik seems to confuse County name and State name.

[Steven_Haught]

@zhbuyiqlik

Got ya. I have had this exact same issue before. I am trying to find my notes or the app to see the work around but not having luck with that the moment! Thought it was done with the concate but may be wrong!  

[zhbuyiqlik]

@Steven_Haught 

Appreciate it!

[Patric_Nordstrom]

In addition to Stevens comment.

In the map we have two options to specify the the type of area, either using the the drop-down. Adm2 if we want counties and Adm1 if we want states.

Or include the type information in the location string:

='Utah:AADM2'

It's always wise to qualify the location with state and country to reduce ambiguity.

='Utah,Utah,US:AADM2'

https://help.qlik.com/en-US/geoanalytics/Content/Qlik_GeoAnalytics/GeoAnalytics-Sense/Location-Servi...

More on the topic:

https://community.qlik.com/t5/Documents/How-to-improve-the-lookup-accuracy/ta-p/1553461

Thanks,

Patric