Qlik Community

Qlik Sense Enterprise Documents

Documents for Qlik Sense related information.

How to create custom map from Excel file

zebhashmi
Valued Contributor

How to create custom map from Excel file

Hello All,

It could be going all around to do so, But I will try to keep in smooth

The first thing you need is a Longitude and Latitude Data of points you want to Draw on the map.

if you want to Draw a Square you need five Points of  Longitude and Latitude

Go to the site and pick your four points for the square you want to Draw on Map fifth point would be the same as one.

https://www.latlong.net/

I am picking the following for this Example.

43.946955, -105.62695344.670216, -93.234375
40.230896, -106.901367

40.163763, -93.234375

Now you want to make a field for that.

Change the top four Points into the following formate.

Note: Longitude and Latitude are Revised. I don't know why? but it has to be this way.

[[[[-105.626953,43.946955],[-93.234375,44.670216],[-106.901367,40.230896],[-93.234375,40.163763],[-105.626953,43.946955]]]]

So you have a field put it in Table with ID.

and you are ready to load in Qlik sence.

IDMapSq
1[[[[-105.626953,43.946955],[-93.234375,44.670216],[-106.901367,40.230896],[-93.234375,40.163763],[-105.626953,43.946955]]]]

LOAD

    ID,

    MapSq

FROM [lib://AttachedFiles/Temp.xlsx]

(ooxml, embedded labels, table is Sheet1);

Tag field MapSq with $geomultipolygon;


Top Bold line is Important

You are Good to Go.  oops, something wrong with my points ... But that how you will do it.

Capture.PNG

Version history
Revision #:
1 of 1
Last update:
‎01-10-2018 04:55 PM
Updated by: