How to Reference Values from other table in Load Resident ?

[#1]

Hi,

I am new to qlikview.

I have below quesition.

Let says we have below dynamic precalculated values in one table.

Table 1 :

               Counts

                100

                 49

                 90

                 48

Table 2 :

         field 1    field 2   field 3

Table 3 :

     Load

             *,

             IF (field 1 > 0,Table 1.100, 0)

             Resident Table 2;

Basically,

My questions,

how can we reference values from other table in the Load Resient table for the Calculations ?

Note : there is no any comment fields or keys between Table 2 and Table 1.

Table 1 field Count has fixed 10 rows which numbers are precalculated and stored in Table 1 field.

and Now, I would like to Reference that calculated numbers in Table 3.

any thoughts ?

Suggestion ?

Thanks in Advance.

[maxgro]

I don't understand how do you choose the value in Table1

Maybe fieldvalue function can help you

Table3:

Load

   *,

   IF (field1 > 0, fieldvalue('Counts', 1),0) as calcfield          // fieldvalue('Counts', 1) = 100

Resident Table2;

[#3]

Thanks for your reply.

is there any way to referes values from other table in If statement ?

Thanks!.