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.
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.
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!