Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi, Please check the post https://community.qlik.com/t5/QlikView-App-Dev/Haversine-formula-to-find-distance-between-two-lat-lo...
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.