help: distance computaion[cluster]

[#1]

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:

[#2]

help plss...

[#3]

Hi,

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

-Alex