topic Re: Find distance between two UK postcodes in QlikView

Find distance between two UK postcodes

paullawrence190 — Wed, 25 Nov 2020 16:16:04 GMT

Had a look through a few posts but cant seem to find an answer.

I have a set of data with two UK postcodes but wanted to work distance between these.

I have an excel currently that does this using google and wondered if any simple way of bringing this logic in to QLik?

Thanks

Paul

Re: Find distance between two UK postcodes

MK9885 — Fri, 31 Mar 2017 15:13:15 GMT

Check the below links.

Haversine formula to find distance between two lat/long points

distance between two coordinates

Re: Find distance between two UK postcodes

paullawrence190 — Fri, 31 Mar 2017 15:15:59 GMT

Thanks looked at these but both need latitude and longitude which i dont have.

Re: Find distance between two UK postcodes

MK9885 — Fri, 31 Mar 2017 15:28:17 GMT

Postcodes?

I don't think postcode will work, as it might change time to time and the distance may not be correct.

I suggest download the Lat & Long for UK or places you want to calculate the distance (if they are not too many data sets, you can hardcode them easily)