Find distance between two UK postcodes

[paullawrence190]

Hi

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

[MK9885]

Check the below links.

Haversine formula to find distance between two lat/long points

distance between two coordinates

[paullawrence190]

Hi

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

[MK9885]

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)