Near distance calculation

[lbrs]

Goodmonring avrybody,

i do have a problem and hope for some advice.

I have an exell file with some house name and their latitude and longitude, i have to calculate the nearest house from one house, and repead this for each house, displayng this in some way, like a distance matrix.

Searching on the comunity i would like to use the heversine formula, but i have no idea how to do the step before.

Is there a way to do this?

Thanks 

Luca

[saso70]

Hi, Please check the post https://community.qlik.com/t5/QlikView-App-Dev/Haversine-formula-to-find-distance-between-two-lat-lo...

[lbrs]

i will use the heversine formula, but the real problem is how to build a "distance matrix" because the pivot table of qlik is kind of difficoult on how to do it. the documentation on the pivot table is not helpfull.