Maps

[Anonymous]

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

[Ralf_Heukäufer]

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]

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

thanks

[Ralf_Heukäufer]

Great,

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

[Anonymous]

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

thanks

[shraddha_g]

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

[Ralf_Heukäufer]

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

[Anonymous]

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

[jurciello]

Hi, Rupesh

also You can look into this topic

KML and Qlik Sense

HIT ,

BR,Yuriy Chayka

[Anonymous]

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