fuzzy * failed

[emilyrabbit]

Hi , in a qlik sense sheet, I want to the record whose [Order Purchase Order Number] field contain ‘TQBH’ not show, so I right the below expression. but the record contains TQBH still show. where am I wrong ?

Pls help me .

=if([Order Purchase Order Number]='*TQBH*',null(),[Order Purchase Order Number])

[Mark_Little]

Hi

You want to look at the wildmatch function

IF(wildmatch([Order Purchase Order Number],*TQBH*'),[Order Purchase Order Number],Null()) 

[rwunderlich]

Or use the like operator:

=if([Order Purchase Order Number] like '*TQBH*',null(),[Order Purchase Order Number])

-Rob

[emilyrabbit]

I am sorry ,I mis the logic, it should when [Order Purchase Order Number] not like "*TQBH*", take [Order Purchase Order Number] ,otherwise null() , how to update it ? thanks

[rwunderlich · Accepted solution]

IF(not wildmatch([Order Purchase Order Number],*TQBH*'),[Order Purchase Order Number],Null()) 

or

if([Order Purchase Order Number] not like '*TQBH*',null(),[Order Purchase Order Number])

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/Operators/Logi...

-Rob

[Qrishna]

if(WildMatch([Order Purchase Order Number], '*TQBH*')<>0, [Order Purchase Order Number]) should suffice.