Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
paullawrence190
Contributor
Contributor

Find distance between two UK postcodes

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

3 Replies
MK9885
Master II
Master II

paullawrence190
Contributor
Contributor
Author

Hi

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

MK9885
Master II
Master II

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)