Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

rupesh632
Contributor

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
Contributor III

Re: Maps

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

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

14 Replies
Ralf_Heukäufer
Contributor III

Re: Maps

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;

rupesh632
Contributor

Re: Maps

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

thanks

Ralf_Heukäufer
Contributor III

Re: Maps

Great,

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

rupesh632
Contributor

Re: Maps

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

thanks

shraddha_g
Honored Contributor III

Re: Maps

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

Ralf_Heukäufer
Contributor III

Re: Maps

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

rupesh632
Contributor

Re: Maps

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

map.png

jurciello
New Contributor II

Re: Maps

Hi, Rupesh

also You can look into this topic

KML and Qlik Sense

HIT ,

BR,Yuriy Chayka

rupesh632
Contributor

Re: Maps

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

Community Browser