Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
alenb
Partner
Partner

Where not match, any of multiple entries

I have a load something like this:

 

DATA:

Load x, y, z From [a.qvd](qvd)

Where Not Match (x, 'a', 'b');

Load x, y, z From [a.qvd](qvd)

Where Not Match (x, 'a', 'b');

 

Is it possible to have a table with the entries ('a', 'b',...) that I would like to exclude, and then simply refer to the whole table.

 

Pseudo code:

EXCLUDE:

Load Inline * [

ITEMS

a

b

]

and then

Where Not Match (x, EXCLUDE);

 

1 Solution

Accepted Solutions
OmarBenSalem
Partner
Partner

You can use the where not exists funcitons, sthing as follow :

Exclude :

load * Inline [
ToExclude
A
B
];

table:
load * Inline [
Field1,Field2
A,1
B,2
C,3
D,4
E,5
F,6
]
where not Exists(ToExclude,Field1)

Capture.PNG

View solution in original post

1 Reply
OmarBenSalem
Partner
Partner

You can use the where not exists funcitons, sthing as follow :

Exclude :

load * Inline [
ToExclude
A
B
];

table:
load * Inline [
Field1,Field2
A,1
B,2
C,3
D,4
E,5
F,6
]
where not Exists(ToExclude,Field1)

Capture.PNG

View solution in original post