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
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
xyz1
Creator III
Creator III

.

.

1 Solution

Accepted Solutions
arulsettu
Master III
Master III

try like this

load  "Order Type"

from table where NOT match("Order Type",'exclude value');

or

load  "Order Type"

from table where "Order Type" NOT IN('exclude value');

View solution in original post

2 Replies
arulsettu
Master III
Master III

try like this

load  "Order Type"

from table where NOT match("Order Type",'exclude value');

or

load  "Order Type"

from table where "Order Type" NOT IN('exclude value');

sravanthialuval
Creator
Creator

try this

Load [Order Type] from Table Name where [Order Type] <>'Exclude value';

@