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>
