Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.
I wanted to draw map for malaysia..can i get the excel sheets with kml files and area fields for states and cities in it
Go to Solution.
The kmz files you can unzip with 7 Zip to a kml file.
I have tried it by myself and created a short testapp :
I don´t know where to find a kml file from malaysia, but here you can find files with geocoordinates:
Or the direct link to the malaysia file:
To read this you can use something like that:
@1 AS country,
@2 AS "post code",
@3 AS city,
@4 AS "federeal state",
@5 AS "federeal state shortcut",
@8 AS district,
'[' & @11 & ','& @10 &']' as geocoordinates
FROM [lib://Path to read from/MY.txt]
(txt, utf8, no labels, delimiter is '\t', msq);
TAG FIELDS geocoordinates WITH $geopoint;
yeah..thanks coordinates... i am having...looking state/city ares/kmls
I am glad that I could help you, if that answers your question please mark my answer as correct.
Sure..I have coordinates information and looking for area\kml info. in same format like csv and all
If you have latitude & longitude information then you can use geomakepoint() to plot on map
I have tried it but it doesn´t work correct with this files.
Right...i wanted to know area info like this
also You can look into this topic
KML and Qlik Sense
yes. this map is available in for UK and USA .Need for asian countries