I have map data in the form of Northings and Eastings, and would like to convert this to Lat and Long so I can display on a Map.
I know there are online tools to do this, but does anyone know a Qlik Sense solution/tool I can use?
I am not aware of any QS tool to do that. I would simply convert the data to Long/Lat and then bring that into your QS app via script.
Hi Chris, can you please share the code please.
The wikipedia article shows the conversion formula you'll want to use:
Universal Transverse Mercator coordinate system - Wikipedia
Thanks Ronald, 2 questions
1) I needed something for British co-ordinate system will UTM to Lat/Lon work?
2) If it works can i code the formula given on wiki into Qlik Code?
I've attached a QVW that does the conversion (only for The Globe Theatre in London but you get the idea) via a (JScript) macro.
This is Awesome Chris thanks, Only Question is how to the same in Qliksense?
Retrieving data ...