Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
tschogren
Contributor II
Contributor II

SOLVED: County Area on Map - no DC?

I'm trying to color every county in the US, but no matter which way I try it, I've been unable to color DC. I've discovered that I have to have the state abbreviation then the county name to make them unique (PA-Erie & NY-Erie), but I am stuck on DC. Is it DC-DC? DC-District of Columbia? DC-D.C.??

There's also a few in WI that won't color when I have nothing selected, but once I click on the state, all the counties will fill in. No idea why. They're using the same format as the rest.

Labels (6)
1 Solution

Accepted Solutions
tschogren
Contributor II
Contributor II
Author

I actually found the solution to my problem. When I went to Qlik Qonnections this year in Dallas, they said that you can use the GeoAnanlytics connector and the "Load" operation to get the list of every type of location data and what Qlik has decided the name should be. The county for the District of Columbia is actually listed as Washington county.

View solution in original post

2 Replies
Ken_Thomas
Support (Former)
Support (Former)

@tschogren  DC is weird, because it is not a state, it is a federal district and falls outside the whole state/county pattern. In general this article may have some steps that can help you with the other items. https://support.qlik.com/articles/000065733
if you have access to a GeoAnalytics environment and have a license for it, using the connector like this can be very useful technique to solve issues where you cannot seem to figure out what values should be to match. 

 

 

 

tschogren
Contributor II
Contributor II
Author

I actually found the solution to my problem. When I went to Qlik Qonnections this year in Dallas, they said that you can use the GeoAnanlytics connector and the "Load" operation to get the list of every type of location data and what Qlik has decided the name should be. The county for the District of Columbia is actually listed as Washington county.

View solution in original post