Easting Northing to Long Lat?

[bwisealiahmad]

Hi,

I have some data which I with Easting Northing location values.

I was wondering if anyone has had any success converting this to Longitude Latitude so that it can be used in Qlik Sense?

Best,

Ali A

[YoussefBelloum]

Hi,

when your data contains longitude and latitude coordinates and you want to use them on a Map on Qliksense, you must use GeoMakePoint() function on the script or on the chart.

GeoMakePoint(Latitude, Longitude)

https://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/Scripting/GeospatialFunctions...

[bwisealiahmad]

Yes but I have it in Northing and Easting which needs to be converted to Long Lat.

[OmarBenSalem]

There is so much tools in the web to convert Northing and Easting to lat lon;

try to convert them with exp this:

UTM to Latitude and Longitude Converter

Then U can use these new lat, lon in ur maps.

ps: When loading geoData (lat, lon) through the data load editor, Qlik Sense will automatically convert each lat,lon combination to a GeoPoint.

if it does not (and it will), u can use GeoMakePoint() function as suggested by Youssef to create ur GeoPoints

[YoussefBelloum]

My bad I didn't understand well your question..

you should use extern solution to convert it.. or try to apply the formula (you can found in online) on the script, but will be complicated and maybe not precise enough..

Good luck

[zebhashmi]

Maybe this will help you once you are done with this conversion

How to create custom map from Excel file

[bwisealiahmad · Accepted solution]

Solved by using Qlik Sense to call on a batch command which does this in QGIS. A free software which has functionality to handle this with Python.

[wesleyfalo]

Hey... how did you do that? Do you have a how-to?

---

@bwisealiahmad wrote:

Solved by using Qlik Sense to call on a batch command which does this in QGIS. A free software which has functionality to handle this with Python.

---

[arpitjayabt]

Hi, I am still not getting any solutions to convert Northing Easting Data to Lat Long. This link above keeps bringing me to the same page. 

[arpitjayabt]

Hi @OmarBenSalem  I have two columns for Northing Easting which I want to plot on QlikSense Geo Map.