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.
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.
