topic help: distance computaion[cluster] in QlikView

help: distance computaion[cluster]

Sun, 13 Mar 2011 10:44:13 GMT

sir,

heres what I want to do during loading..

1. compare each ID to every ID in the table.

2. If the ID is not equal to itself it will not compute the distance(latitude and longitude).

3. have a counter that will indicate if there are more than 5 IDs that is less than 5kms from the source ID.

if counter = 5, exit script

here's the picture:

Sun, 13 Mar 2011 14:45:18 GMT

help plss...

Mon, 14 Mar 2011 07:54:51 GMT

Hi,

See here how to compute distance between two points http://community.qlik.com/forums/t/42222.aspx

-Alex