Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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';

@