topic Near distance calculation in Connectivity & Data Prep

Near distance calculation

lbrs — Wed, 21 Sep 2022 07:16:46 GMT

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

Re: Near distance calculation

saso70 — Wed, 21 Sep 2022 09:11:04 GMT

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

Re: Near distance calculation

lbrs — Wed, 21 Sep 2022 09:39:22 GMT

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.