Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

agrimroquette
Contributor II

How to exclude a value?

Dear All,

I have a column name "Order Type", i want to exclude only one order type value to be display in qlik filter(from script).

please help

1 Solution

Accepted Solutions
arulsettu
Honored Contributor III

Re: How to exclude a value?

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

2 Replies
arulsettu
Honored Contributor III

Re: How to exclude a value?

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
Contributor

Re: How to exclude a value?

try this

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

@