Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tmahmood
Contributor
Contributor

Exclude data from combination of two columns in qlik sense

Hi All,

I am trying to exclude data in load statement for the combination of two columns. Here is what I am trying to achieve.

System            Type

DUI                   test        

BD1                  test

PU1                  test

EP5                  test

ED5                  test

GRD                 test

GRP                 test

I want to exclude data where  System in DU1, BD1,ED5 and type = test.

I tried below but does not seem working correctly as it excludes all the values of DU1, BID and ED5 and all test

And NOT MATCH (System, 'DU1', 'ED5','BID')   and Type = 'test'

I am new to Qlik sense. Please help.

Thank you              

3 Replies
tmahmood
Contributor
Contributor
Author

Can you please post answer here as cant access that group

sunny_talwar

Option 1

And NOT (MATCH (System, 'DU1', 'ED5','BID') and Type = 'test')

Option 2

And Not Match(System, 'DU1', 'ED5', 'BID') or Type <> 'test'