topic Exclusion based on column values in QlikView https://community.qlik.com/t5/QlikView/Exclusion-based-on-column-values/m-p/1313109#M843444 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>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.</P><P></P><P>ex: C1 [Name 1, Name 2]</P><P>C2 [ Name 0, Name 1, Name 2, Name 3, Name 4 ...]</P><P></P><P>The result should show contents of C2 as Name 0, Name 3, Name 4 ...]</P><P></P><P>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.</P><P></P><P>Please do share the possible solution if available.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Exclusion based on column values https://community.qlik.com/t5/QlikView/Exclusion-based-on-column-values/m-p/1313109#M843444 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>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.</P><P></P><P>ex: C1 [Name 1, Name 2]</P><P>C2 [ Name 0, Name 1, Name 2, Name 3, Name 4 ...]</P><P></P><P>The result should show contents of C2 as Name 0, Name 3, Name 4 ...]</P><P></P><P>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.</P><P></P><P>Please do share the possible solution if available.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Exclusion-based-on-column-values/m-p/1313109#M843444 Anonymous 2020-11-25T16:16:04Z