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: 
Anonymous
Not applicable

Qlik Sense Mapping and County KML

I am trying to load County KML file Cartographic Boundary KML Files - Counties - Geography - U.S. Census Bureau to Sense and there is a problem with it.

If you just drop that KML file to Qlik Sense, the county is identified by its name:

2014-11-28 15_32_57-Qlik Sense Desktop.png

this is a problem because there duplicated by county name. It is not a Qlik Sense issue - census people really should have been used FIPS code instead but the question I have for you guys if it is possible somehow to use other attributes from KML file. They do have FIPS code in there, but it is rather recorded under GEOID note not NAME:

<SimpleData name="GEOID">12095</SimpleData>

<SimpleData name="NAME">Orange</SimpleData>

11 Replies
Anonymous
Not applicable
Author

Sergey_Despot
Contributor III
Contributor III

After loading the KML as KML, open the same as the XML
Further, through simple JOIN, you can enrich the data