KML Hell. Polygon Area coordinates not recognized by Qlik Sense

mikegrattan — Thu, 24 May 2018 20:00:36 GMT

I have a KML file with polygon area coordinates for each location. The KML will import into Qlik and show the areas in a Map chart object, but only shows one of five "name" fields. I wanted to import three name fields and associate those with their respective areas, but the only way I could think of doing that was to convert the KML to a CSV. That works, and gives me data like this, which has the polygon data surrounded in quotes:

Grower,Ranch,Lot,Coordinates

A.C.,Ranch 1,2,"-121.5506385,36.62011583333334,0

-121.5506386666667,36.62011599999998,0

-121.5506383333334,36.62011533333334,0

-121.5506381666666,36.62011516666666,0

-121.5506376666667,36.62011516666666,0

-121.550637,36.62011483333334,0

-121.5488317333773,36.61836742664507,0

-121.5488197413706,36.61835917032325,0

-121.5488064372906,36.61834979673374,0

-121.5487932764501,36.61834105912738,0

-121.5487801729053,36.61833609731286,0

-121.5487661698168,36.61833244757172,0

-121.5487525162325,36.61833245903087,0

-121.5487372354481,36.61833449303104,0

-121.5487211697116,36.61833924285118,0

-121.548707017654,36.61834277227113,0

-121.5487028178734,36.61834253162886,0

-121.5487022277269,36.61834183834999,0

-121.5476818013529,36.6189947466758,0

-121.5476772635271,36.61900305456386,0

-121.5476718719943,36.61901488614233,0

-121.5476700900955,36.61902793239129,0

-121.547671333414,36.61904289231935,0

-121.5476762894989,36.61905753139102,0

-121.5476827925699,36.61907155166824,0

-121.5476919942721,36.61908400204113,0

-121.5476952544019,36.61908761167528,0

-121.5476976780134,36.61908344054253,0

-121.5482874406606,36.6196950271522,0

-121.5482874864973,36.6196948438057,0

-121.548287910486,36.61969490110147,0

-121.5482880709142,36.61969431668452,0

-121.5482861686944,36.61969470056624,0

-121.5479700163126,36.61989636452138,0

-121.5479703199802,36.6198966510003,0

-121.5479698788027,36.6198967598623,0

-121.5479656045375,36.61989759638068,0

-121.54793638369,36.61998551102472,0

-121.5479358451097,36.61998655953752,0

-121.5479353867434,36.61998690904174,0

-121.5479356617632,36.6199870522812,0

-121.5490414015528,36.62110406215072,0

-121.5490415333331,36.62110387307465,0

-121.5490418083529,36.62110371264645,0

-121.5490420432656,36.62110389599295,0

-121.549042186505,36.62110411371691,0

-121.5490422151529,36.6211045663536,0

-121.5490427250853,36.62110453770568,0

-121.5506385,36.62011583333334,0"

Unfortunately, when I import this file into Qlik Sense it no longer recognizes that the Coordinates field has polygon area data in it. I tried changing the field type to Geo, but Qlik only gives me choices of City, Country, Country code ISO2, and Country code ISO3 for Geo data.

Is there a way to import polygon area data from a CSV so that Qlik Map Chart will work? Or is there another way of importing this data from the KML so it will recognize all three of my location names?

Thanks.

Placemark section of original KML looks like this:

<name>Ranch 1</name>

<styleUrl>#falseColor</styleUrl>

<colorMode>random</colorMode>

</IconStyle>

<colorMode>random</colorMode>

</LineStyle>

<colorMode>random</colorMode>

</PolyStyle>

</Style>

<SimpleData name="Ranch">Ranch 1</SimpleData>

</SchemaData>

</ExtendedData>

-121.5506385,36.62011583333334,0 -121.5506386666667,36.62011599999998,0 -121.5506383333334,36.62011533333334,0 -121.5506381666666,36.62011516666666,0 -121.5506376666667,36.62011516666666,0 -121.5506376666667,36.62011516666666,0 -121.550637,36.62011483333334,0 -121.5488317333773,36.61836742664507,0 -121.5488197413706,36.61835917032325,0 -121.5488064372906,36.61834979673374,0 -121.5487932764501,36.61834105912738,0 -121.5487801729053,36.61833609731286,0 -121.5487661698168,36.61833244757172,0 -121.5487525162325,36.61833245903087,0 -121.5487372354481,36.61833449303104,0 -121.5487211697116,36.61833924285118,0 -121.548707017654,36.61834277227113,0 -121.5487028178734,36.61834253162886,0 -121.5487022277269,36.61834183834999,0 -121.5476818013529,36.6189947466758,0 -121.5476772635271,36.61900305456386,0 -121.5476718719943,36.61901488614233,0 -121.5476700900955,36.61902793239129,0 -121.547671333414,36.61904289231935,0 -121.5476762894989,36.61905753139102,0 -121.5476827925699,36.61907155166824,0 -121.5476919942721,36.61908400204113,0 -121.5476952544019,36.61908761167528,0 -121.5476976780134,36.61908344054253,0 -121.5482874406606,36.6196950271522,0 -121.5482874864973,36.6196948438057,0 -121.548287910486,36.61969490110147,0 -121.5482880709142,36.61969431668452,0 -121.5482861686944,36.61969470056624,0 -121.5479700163126,36.61989636452138,0 -121.5479703199802,36.6198966510003,0 -121.5479698788027,36.6198967598623,0 -121.5479656045375,36.61989759638068,0 -121.54793638369,36.61998551102472,0 -121.5479358451097,36.61998655953752,0 -121.5479353867434,36.61998690904174,0 -121.5479356617632,36.6199870522812,0 -121.5490414015528,36.62110406215072,0 -121.5490415333331,36.62110387307465,0 -121.5490418083529,36.62110371264645,0 -121.5490420432656,36.62110389599295,0 -121.549042186505,36.62110411371691,0 -121.5490422151529,36.6211045663536,0 -121.5490427250853,36.62110453770568,0 -121.5506385,36.62011583333334,0

</coordinates>

</LinearRing>

</outerBoundaryIs>

</Polygon>

</Placemark>

Re: KML Hell. Polygon Area coordinates not recognized by Qlik Sense

zaini — Thu, 05 Sep 2019 11:58:06 GMT

hi mikegrattan,

have you tackled this isssue yet? I am having the same problem right now and have no clue how to solve it.. any help would be appreciated!

topic KML Hell. Polygon Area coordinates not recognized by Qlik Sense in Connectivity & Data Prep

KML Hell. Polygon Area coordinates not recognized by Qlik Sense

Re: KML Hell. Polygon Area coordinates not recognized by Qlik Sense