topic Re: Import KML file created with Google in QlikView

Import KML file created with Google

Mon, 09 May 2016 17:15:06 GMT

I am trying to import a KML file in Qlik View that was created with Google My Maps. The Map has several areas of a city drawn as Polygons.

I have tried everything to import the Map but it simply won't load in Qlik View. In Qlik Sense I am able to load the KML without a problem with OpenStreetMaps as a background. Also the file loads without any problem in Google Earth. I have tried several extensions such as GeoClick, Geospatial map but no joy. Also I have followed multiple step-by-step tutorials only to be able to draw a Google Map of the world but the polygons won't apear.

What I would like to do is to have the different areas of the city have a colour based on an expression. I am beginning to doubt if this is possible at all.

Hopelfully someone can point me in the right direction! Attached is the KML I would like to import to Qlik View.

Re: Import KML file created with Google

settu_periasamy — Tue, 10 May 2016 05:04:14 GMT

Have you tried with XML option in the Import Wizard?

For me, it seems to be working.. see the below screen shot..

Re: Import KML file created with Google

Tue, 10 May 2016 05:50:11 GMT

Yes. I can load the file correctly and show all fields in a straight table. The problem is that I cannot plot anything on a map.

Re: Import KML file created with Google

avinashelite — Tue, 10 May 2016 05:53:56 GMT

check this threads

KML US and World Map and Sample Data

Open Source Geospatial Mapping Extension using KML files

Re: Import KML file created with Google

Anonymous — Tue, 10 May 2016 06:58:47 GMT

KML US and World Map and Sample Data

TRY THIS ONE

Re: Import KML file created with Google

Tue, 10 May 2016 08:17:08 GMT

I appreciate your response! However I already tried both threads without any luck.

KML US and World Map and Sample Data

This links to a turtorial for Qlik Sense. I can plot the map in Qlik Sense but want to do this in Qlik View.

Open Source Geospatial Mapping Extension using KML files

As soon as I try the extension in WebView mode, rename KML to XML and place in correct folder the map draws blank. Tried it in every way.

My data table and map chart looks as below.

The KML file should look as below in the screenshot from Google My Maps editor.

In what way should I input the coordinates in the map chart? Are the coordinates the right format?

Re: Import KML file created with Google

Thu, 12 May 2016 07:47:10 GMT

Anyone?

Re: Import KML file created with Google

avinashelite — Thu, 12 May 2016 15:57:18 GMT

Currently, I don't have a QV license so I am not able to open the example file

did you checked this points.

1.Region Name: this should be set to the dimension holding region names. If the name doesn't match up to the name within KML data, the connection will not be made, so if a given region isn't rendering on the map, that's probably why. More will be explained below in the "Working with KML" section.

2.The KML region names need to be the same as the QV data - If you're loading in the data for the US States, for example, and the dimension you're using uses the state abbreviations, the <name> in the KML for each state needs to match up. Again, this will probably not be something you need to write yourself, but if you load in your data and notice that some regions aren't showing up, make sure the data matches the KML names. Your data might have a region named something slightly different, so finding that name in the KML and changing it would be easy.