Lookup the result of one expression in a table and use in another

[#1]

Hi,

I'm using a qlikview extension and need all the data for the extension to be returned in the same straight table.

What I am doing is mapping routes from one site to another using x,y coordinates, lines and symbols. I want the table to work dynamically so that the symbols and lines move depending on sites selected.

I can do this for the sites, by ranking them based on longitude and latitude, counting the number of sites that I need to chart and calculating the x,y coordinates using the rank of the site and the overall width and height of the chart. This will calculte dynamically as you select different groups of sites.

Site     x                         y          Linked Site     xLink     yLink

A        10                        80         C

B        20                        60         A  

C        30                        50         E

D        40                        30         G

E        60                        20         A

F        70                        40         G

G        80                        10         B

Now I want to draw a line from the Sites, to the Link Sites. To do this i need to now that start coordinates (have these) and the end ones, to get the end ones I need to get the value of x and y WHEN site = Linked Site. But these values are calculated in the same table in different columns. Is there a way I can wrote a formula to poulate xLink and yLink by looking at the Site column and returneing the relevant x and y value?

Does that make any sense at all?

My other option is to stop thinks moving dynamically on selection and just give the sites fixed coordinates. Not what I wanted to do though.

Any help would be appreciated