Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
JMAROUF
Creator II
Creator II

condition between two tables

Hello every one,

i have two table A(x,y) and table B(x,z),   create a straight table with this condition:

if  z = null  so  show x,y

Labels (2)
1 Solution

Accepted Solutions
Anil_Babu_Samineni
MVP
MVP

Straight forward question, Simply load as it is those 2 tables. and in design, you can use condition like

If(IsNull(Z), X)

If(IsNull(Z), Y)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

1 Reply
Anil_Babu_Samineni
MVP
MVP

Straight forward question, Simply load as it is those 2 tables. and in design, you can use condition like

If(IsNull(Z), X)

If(IsNull(Z), Y)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful