Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

bwisealiahmad
Valued Contributor

Easting Northing to Long Lat?

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

1 Solution

Accepted Solutions
bwisealiahmad
Valued Contributor

Re: Easting Northing to Long Lat?

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.

6 Replies
YoussefBelloum
Esteemed Contributor

Re: Easting Northing to Long Lat?

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

Re: Easting Northing to Long Lat?

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

omarbensalem
Esteemed Contributor

Re: Easting Northing to Long Lat?

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

Re: Easting Northing to Long Lat?

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

Re: Easting Northing to Long Lat?

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

How to create custom map from Excel file

bwisealiahmad
Valued Contributor

Re: Easting Northing to Long Lat?

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.