If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have a load something like this:
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.
Load Inline * [
Where Not Match (x, EXCLUDE);
You can use the where not exists funcitons, sthing as follow :
load * Inline [ToExcludeAB];
table:load * Inline [Field1,Field2A,1B,2C,3D,4E,5F,6]where not Exists(ToExclude,Field1)
View solution in original post