Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can you please post answer here as cant access that group
Option 1
And NOT (MATCH (System, 'DU1', 'ED5','BID') and Type = 'test')
Option 2
And Not Match(System, 'DU1', 'ED5', 'BID') or Type <> 'test'