Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everybody
I am perfectly capable of loading kml files of the type "polygon" and "point" into QlikView and Qlik Sense. Though I am not able to load kml files of the type "line". Has anybody managed to do this and if yes, could you provide an example comprising
1) a sample kml file containing one or more lines
2) the corresponding code of the script editor (QlikView or Qlik Sense).
Both for QlikView and Qlik Sense I have downloaded and installed the necessary GeoAnalytics extension files.
Thank you!
Hi Simon,
The built-in support for KML only loads points and polygons.
But you can load it as xml, rename file and then add some brackets to make it a proper Sense geometry like this:
railway:
LOAD
id,
name,
'[[' & replace("LineString/coordinates", ' ' , '],[') & ']]' as line_geom,
"ExtendedData/SchemaData/SimpleData"
FROM [lib://railways/railways.xml]
(XmlSimple, table is [kml/Document/Folder/Placemark]);
The railway kml file is borrowed from the City of Vancouver
Thanks,
Patric Nordström
Qlik
Hi Simon,
The built-in support for KML only loads points and polygons.
But you can load it as xml, rename file and then add some brackets to make it a proper Sense geometry like this:
railway:
LOAD
id,
name,
'[[' & replace("LineString/coordinates", ' ' , '],[') & ']]' as line_geom,
"ExtendedData/SchemaData/SimpleData"
FROM [lib://railways/railways.xml]
(XmlSimple, table is [kml/Document/Folder/Placemark]);
The railway kml file is borrowed from the City of Vancouver
Thanks,
Patric Nordström
Qlik
Thank you, Patric! This workaround solves the problem.
Best regards
Simon
Hi does it work with default Map available with Qlik Sense
No, sorry, only the Qlik GeoAnalytics map object.