Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bwisealiahmad
Partner
Partner

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
Partner
Partner
Author

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.

View solution in original post

9 Replies
YoussefBelloum
Champion
Champion

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
Partner
Partner
Author

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

OmarBenSalem
Partner
Partner

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
Champion
Champion

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
Specialist
Specialist

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

How to create custom map from Excel file

bwisealiahmad
Partner
Partner
Author

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.

View solution in original post

wesleyfalo
Contributor
Contributor

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

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

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