Solved: Re: How to exclude a value? - Qlik Community - 1230814

Skip to main content

Qlik.com | Qlik Help | Resources

Ask a Question

.

1 Solution

Accepted Solutions

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

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');

try this

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

@