topic Re: How to Reference Values from other table in Load Resident ? in QlikView

How to Reference Values from other table in Load Resident ?

Sat, 21 Jun 2014 21:34:57 GMT

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

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 — Sat, 21 Jun 2014 21:53:36 GMT

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;

Sat, 21 Jun 2014 22:07:26 GMT

Thanks for your reply.

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

Thanks!.