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: 
Anonymous
Not applicable

Exclusion based on column values

Hello,

We have two columns [say C1 and C2] which contain names. We need to display the names in Column C2 that are not present in column C1.

ex: C1 [Name 1, Name 2]

C2 [ Name 0, Name 1, Name 2, Name 3, Name 4 ...]

The result should show contents of C2 as Name 0, Name 3, Name 4 ...]

Tried using set expression, concat and match options, but none seems to work. It should be an easy task, but could not find any relevant info so far.

Please do share the possible solution if available.

0 Replies