topic Nearest distance calculation in QlikView

Nearest distance calculation

AH — Tue, 08 May 2018 01:29:17 GMT

I have the X and Y coordinate in the Pos.txt file with a PosID field and

X and Y coordinate in the Dod.txt file with an ID field.

My goal is to consolidate this two-tables into one table based on the X and Y coordinate.

So, what ‘PosID’ falls under what ‘ID’ based on the nearest X & Y coordinates of the PosID to the X & Y coordinates of the ‘ID’ field? is the condition to achieve this goal.

Any Help is highly appreciated.

Thanks & Regards,

Re: Nearest distance calculation

duncanblaine — Tue, 08 May 2018 08:18:07 GMT

Hi Shan

I found a few posts about similar calculations and I've applied them to an app that demonstrates what I hope you're after.

The crucial part of the calculation is the Distance Calculation which is done using a Macro.

If found reference to that here distance between two coordinates

Your requirement is a bit different to that example as you want to group certain locations under others based on distance. My app shows how to do that. It ended up being simpler than I thought.

Hope this helps.

Re: Nearest distance calculation

AH — Thu, 10 May 2018 00:21:25 GMT

Hi Duncan,

Thank you so much for the solution! It works great.

Regards,