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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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