Using Qlik-Switch to not show numbers with prefix in an If-Statement

[Applicable88]

Hello,

I have ordernumbers in a straight table. 

Ordernumber	Date
1234567	12.09.2020
9874561	13.09.2020
2584658	14.09.2020
5687412	15.09.2020
9632584	16.09.2020
F881234	17.09.2020
F881289	18.09.2020
F881225	19.09.2020

Now I want to use a QlikSwith, and when it turns on I want all numbers with the prefix 'F88*' not displayed, but the others stay displayed. 

I hope someone has Idea for an If-statement solution.

Thank you in advance!

[Waïl_Riachi_Sanofi]

Hello,

For Example,

count({$<Ordernumber-= {"*F88"}>} Your Variable)

Or using variable : 

SET vF88= "*F88";

count({$<Ordernumber-= {$(vF88)}>} Your Variable)

[Applicable88]

Hi,

thanks for the quick reply, but I need a If-statement for that, because qlikswitch is like on and off. So like boolean kind of query. 

[Applicable88 · Accepted solution]

Hi,

once again I tried to negate the function with something like NOT WILDMATCH, but still didn't get the prefix filtered out. The "Not" is not returning the "opposite" of the wildmatch.

Instead I tried to equal the wildmatch with the null() function. 
Like this: =if(WildMatch([Ordernumber, 'F88*'),null(), 'F88-Numbers filtered')
That works as I wanted. 

Best.