Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mg862925
New Contributor

Exclude values from filter

I want to exclude value in i a filter.

This is correct 

Count({$<[Status]={'Quoted'}>} [Status])

But after that I need to exclude some more from an other "Booked for Shipping Date"

I tried this =if(WildMatch ([Booked for Shipping Date],'20*'),null(),[Booked for Shipping Date])

But that didnt work.

See my csv file

1 Solution

Accepted Solutions
Channa
Valued Contributor III

Re: Exclude values from filter

missingcount([Booked for Shipping Date])

Channa

View solution in original post

9 Replies
Channa
Valued Contributor III

Re: Exclude values from filter

if(match ([Booked for Shipping Date],'20*'),null(),[Booked for Shipping Date])

or

if([Booked for Shipping Date] like '20*',null(),[Booked for Shipping Date])

 

try

Channa
mg862925
New Contributor

Re: Exclude values from filter

it didnt work

I want this number to be reduced (I want to exclude all the "booked for shipping")

So to explain I want the filter to say "exclude all the "booked for shipping" or include all the "booked for shipping"

I want to display both options for different people at my work

Channa
Valued Contributor III

Re: Exclude values from filter

you want to add condition to this

Count({$<[Status]={'Quoted'}>} [Status])

 

IF( isMissing(BookedForShipping ),Count({$<[Status]={'Quoted'}>} [Status])

 

=if(Match ([Booked for Shipping Date],'20*'),null(),count([Booked for Shipping Date]))

Channa
mg862925
New Contributor

Re: Exclude values from filter

=if(Match ([Booked for Shipping Date],'20*'),null(),count([Booked for Shipping Date]))

This Includes the "booking for shipping"

I get the correct number but I want it the other way

Only count the one that DONT have a booking for shipping

 

BTW

Thanks for all the help!

 

Channa
Valued Contributor III

Re: Exclude values from filter

=if(not Match ([Booked for Shipping Date],'20*'),null(),count([Booked for Shipping Date]))

 

TRY

Channa
mg862925
New Contributor

Re: Exclude values from filter

No same number.

The number should be 1052

but right now it is 22119

see the file

 

Channa
Valued Contributor III

Re: Exclude values from filter

Booked for shipping always showing null

 

may be you need to count distinct 

Channa
mg862925
New Contributor

Re: Exclude values from filter

Yeah or should I go on "tracking ID" instead?

Maybe something to do with the date?

Channa
Valued Contributor III

Re: Exclude values from filter

missingcount([Booked for Shipping Date])

Channa

View solution in original post