Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

KML Hell. Polygon Area coordinates not recognized by Qlik Sense

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.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:

<Placemark>

<name>Ranch 1</name>

<styleUrl>#falseColor</styleUrl>

<Style id="inline">

<IconStyle>

<colorMode>random</colorMode>

</IconStyle>

<LineStyle>

<colorMode>random</colorMode>

</LineStyle>

<PolyStyle>

<colorMode>random</colorMode>

</PolyStyle>

</Style>

<ExtendedData>

<SchemaData schemaUrl="#S_SalinasPartner_LotsMaster_SSSDSS">

<SimpleData name="Grower">A.C.</SimpleData>

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

<SimpleData name="Lot">2</SimpleData>

<SimpleData name="Area_Acres">10.3</SimpleData>

<SimpleData name="Acres_froz">10.3387</SimpleData>

<SimpleData name="Conv_Organ">c</SimpleData>

</SchemaData>

</ExtendedData>

<Polygon>

<outerBoundaryIs>

<LinearRing>

<coordinates>

-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>

<Placemark>

1 Reply
Highlighted
Contributor
Contributor

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!