Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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..

1 Reply
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!