Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
zhbuyiqlik
Contributor II
Contributor II

Qlik Area Map Error When County Name=State Name

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.

zhbuyiqlik_0-1621884470871.png

Figure 2:  This is what should look like

zhbuyiqlik_1-1621884521301.png

 

 

5 Replies
Steven_Haught
Creator III
Creator III

@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
Contributor II
Contributor II
Author

@ 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
Creator III
Creator III

@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
Contributor II
Contributor II
Author

@Steven_Haught 

Appreciate it!

Patric_Nordstrom
Employee
Employee

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.

Patric_Nordstrom_0-1622011678421.png

 

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