Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

borisman
Contributor III

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>

Tags (3)
1 Solution

Accepted Solutions
Not applicable

Re: Qlik Sense Mapping and County KML

Hi Boris,

I have solved the problem using QGIS. http://www.qgis.org/en/site/

The solution is:

  1. Open the boundary file in QGIS (in my case I opened a MapInfo Tab file. You can open many formats.)
  2. Right click on boundary and "Save As"
  3. Choose KML as the format you want to save us
  4. Under data source options type in the the field you want to map to the name field
  5. Press OK

When I import this into Sense I now have the key field stored in the name field which makes it easy to join to the data model.

Regards,

Tim

10 Replies

Re: Qlik Sense Mapping and County KML

I believe you can use any field as a key, as long as you can link it back to your fact data. So if you have FIPS code linked to your facts, then yes.

-Rob

borisman
Contributor III

Re: Qlik Sense Mapping and County KML

unfortunately if you use KML format, Qlik Sense only shows/loads three fields - Name, Point and Area. Point one is always empty. It does not show/load any other attributes from KML file

plexpro52
Contributor

Re: Qlik Sense Mapping and County KML

Boris, I have run into this issue also, and am wondering whether you found a solution.

borisman
Contributor III

Re: Qlik Sense Mapping and County KML

I did not find an easy way unfortunately.

I think i almost got it work by replacing the Name attribute with CountyState code - I wrote regex to do that but then I gave up - it was something I did for proof-of-concept and it did not go that well.

Another option i was entertaining is to use spatial tools and rebuild KML file itself.

Not applicable

Re: Qlik Sense Mapping and County KML

Hi Boris,

I have solved the problem using QGIS. http://www.qgis.org/en/site/

The solution is:

  1. Open the boundary file in QGIS (in my case I opened a MapInfo Tab file. You can open many formats.)
  2. Right click on boundary and "Save As"
  3. Choose KML as the format you want to save us
  4. Under data source options type in the the field you want to map to the name field
  5. Press OK

When I import this into Sense I now have the key field stored in the name field which makes it easy to join to the data model.

Regards,

Tim

borisman
Contributor III

Re: Qlik Sense Mapping and County KML

awesome, thanks for sharing your workaround, Tim!

Not applicable

Re: Qlik Sense Mapping and County KML

No worries, Boris

I noticed this qlik branch project yesterday which you might be interested in. It looks quite good compared to the default sense maps. GoogleMapsAPIv3Toolkit-QS

Highlighted
borisman
Contributor III

Re: Qlik Sense Mapping and County KML

interesting project but unfortunately google maps API would be off limit for most commercial applications unless you get a full license (starts at $10,000 annually). at some point i did an extensive research and contacted google team to clarify license agreement. in a nutshell, if you work for someone and use google map API and that application is not accessible to public (not only employees of your company but the entire world), then you will be violating license agreement. Same thing with Microsoft. The only truly free solution i found back then was MapQuest open API which worked great for us. so keep this in mind

hgpatel172
Contributor

Re: Qlik Sense Mapping and County KML

Hi Tim,

Can you please explain these steps in bit detail if possible or provide some link to perform these steps.

I too want a kml file along with Geo ID (since few Counties are with same name and different Geo IDs and they're meshing things up).

Regards,

Hardik