Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Maps

Hi Expert,

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

thanks

1 Solution

Accepted Solutions
Ralf_Heukäufer
Partner - Creator III
Partner - Creator III

The kmz files you can unzip with 7 Zip to a kml file.

I have tried it by myself and created a short testapp :

View solution in original post

14 Replies
Ralf_Heukäufer
Partner - Creator III
Partner - Creator III

Hello Rupesh,

I don´t know where to find a kml file from malaysia, but here you can find files with geocoordinates:

GeoNames

Or the direct link to the malaysia file:

http://download.geonames.org/export/zip/MY.zip

To read this you can use something like that:

LOAD

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

Anonymous
Not applicable
Author

yeah..thanks coordinates... i am having...looking state/city ares/kmls

thanks

Ralf_Heukäufer
Partner - Creator III
Partner - Creator III

Great,

I am glad that I could help you, if that answers your question please mark my answer as correct.

Anonymous
Not applicable
Author

Sure..I have coordinates information and looking for area\kml info. in same format like csv and all

thanks

shraddha_g
Partner - Master III
Partner - Master III

If you have latitude & longitude information then you can use geomakepoint() to plot on map

Ralf_Heukäufer
Partner - Creator III
Partner - Creator III

I have tried it but it doesn´t work correct with this files.

Anonymous
Not applicable
Author

Right...i wanted to  know area info like this

map.png

jurciello
Contributor III
Contributor III

Hi, Rupesh

also You can look into this topic

KML and Qlik Sense

HIT ,

BR,Yuriy Chayka

Anonymous
Not applicable
Author

yes. this map is available in for UK and USA .Need for asian countries