Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

harjit_nar
New Contributor

How to convert from BNG to Lat Long?

Hi,


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?

Thanks,

7 Replies
rittermd
Honored Contributor

Re: How to convert from BNG to Lat Long?

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.

cfitzpatrick69
New Contributor II

Re: How to convert from BNG to Lat Long?

Many years ago I converted a piece of Java code that did the conversion into a QlikView Javascript macro if that's any good? Conversion from/to: lat-long, Eastings/northings and OS grid ref at a rate of about 100,000 a second.

anwar_qlik
New Contributor III

Re: How to convert from BNG to Lat Long?

Hi Chris, can you please share the code please.

Regards,

ASP

ronalddoes
Contributor III

Re: How to convert from BNG to Lat Long?

The wikipedia article shows the conversion formula you'll want to use:

Universal Transverse Mercator coordinate system - Wikipedia

anwar_qlik
New Contributor III

Re: How to convert from BNG to Lat Long?

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?

Regards,

Anwar

cfitzpatrick69
New Contributor II

Re: How to convert from BNG to Lat Long?

Hi Anwar

Sure

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.

Enjoy !

anwar_pardawala
New Contributor

Re: How to convert from BNG to Lat Long?

This is Awesome Chris thanks, Only Question is how to the same in Qliksense?