How to create one field using multiple fields from previous tables?

[#1]

I have a Table like

A:

Load

X

Y

From ....

By  using A table, i am creating  a new fields like  P and Q. By using resident load

B:

load *,

If(X=1,'True','False') as P,

if(Y=0,'True','False') as Q

Resident A;

Now i need to create another field like 'Z' help of  A and B table fields( X, P, Q)..

How to create one field using multiple fields from previous tables?

Thanks for advance..

[kaushiknsolanki]

Hi,

I feel you need preceding load instead of resident.

Do something like this.

Load *,if(P=Q,1,0) as NewField;

Load *,

If(X=1,'True','False') as P,

if(Y=0,'True','False') as Q;

Load X,Y,Z from xyz;

Benefit of using Preceding load ..

https://www.quickintelligence.co.uk/preceding-load-qlikview/

Regards,

Kaushik Solanki