Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Newton
Contributor III
Contributor III

Show value if it's exists in both fields

I have two fields with plenty of usernames and want to display [Field 1] values, but only if it's also exists in [Field 2], how can I do that?

Example:

[Field 1] [Field 2]
Name A Name C
Name F Name X
Name C  
Name O  

 

A table or chart that use [Field 1] shoud only display "Name C".

 

Labels (5)
1 Reply
Chanty4u
MVP
MVP

Here's an example expression that you can use to create a new field:

 

=if(Match([Field 1], [Field 2]), [Field 1]) as newfield