Qlik Sense KML File Expression issue?

[ishansjain2095]

Hi All,

Facing Issue in my Qlik Sense Hub i.e. not able to map .name col values and .area col values from XML codes shown below:

CODE:

<?xml version="1.0" encoding="utf-8" ?>
<kml xmlns="http://www.opengis.net/kml/2.2">
<Document id="root_doc">
<Schema name="IND_DIST" id="gadm36_IND_2">
<SimpleField name="NAME_0" type="string"></SimpleField>
<SimpleField name="NAME_1" type="string"></SimpleField>
<SimpleField name="NAME_2" type="string"></SimpleField>
</Schema>
<Folder><name>gadm36_IND_2</name>
<Placemark>
<Style><LineStyle><color>ff0000ff</color></LineStyle><PolyStyle><fill>0</fill></PolyStyle></Style>
<ExtendedData><SchemaData schemaUrl="#gadm36_IND_2">
<SimpleData name="NAME_0">India</SimpleData>
<SimpleData name="NAME_1">Andaman and Nicobar</SimpleData>
<SimpleData name="NAME_2">Nicobar Islands</SimpleData>
</SchemaData></ExtendedData>

<MultiGeometry><Polygon><outerBoundaryIs><LinearRing><coordinates>93.78772736,6.85264015 93.7884903,6.85257101 93.78904724,6.85257101 93.78904724,6.85229111 93.78967285,6.85229111 93.78987885,6.85201311 93.7901535,6.85194492 93.79064178,6.85166693 93.79077911,6.85138893 93.79091644,6.85104179 93.79050446,6.85062504 93.79029083,6.85034704 93.79000092,6.85027885 93.78948212,6.84990311 93.78900146,6.84948492 93.78837585,6.84913683 93.78801727,6.84872007 93.78778076,6.84805584 93.7875061,6.84806108 93.78721619,6.84778118 93.78639221,6.84778118 93.78610992,6.84806108 93.78527832,6.84806108 93.78443909,6.84889984 93.78444672,6.84916592 93.78549194,6.84992981 93.78625488,6.85062504 93.78676605,6.85117197 93.78694153,6.85167122 93.7873764,6.85166693 93.7873764,6.85208416 93.78730774,6.85235882 93.7873764,6.85257101 93.78772736,6.85264015</coordinates></LinearRing></outerBoundaryIs></Polygon>

etc.

And sharing you guys some of my screenshots in zip file.

Regards,

Ishan

Software Engineer

[dmoon2208]

Hi.

I use QGIS to import the KML and then use the export function to save it as a CSV 

[ishansjain2095]

Hi Dmoon2208,

I also used QGIS to import the .shp file downloaded from gadm.org and export the function to save it as KML. But now I learnt from you and other guys how to read kml as xml and map chart can also be mapped with csv.

Thank you,

Guys