Exclude Data from a Wildmatch Expression

[Anonymous]

Hi, I need to exude data from a wildmatch expression in QlikSense

If(WildMatch([Item - Item Number], '10-401' , '10-403'), ' Classic',

If(WildMatch([Item - Item Number], '401LITE' , '401LITE'), 'Lite',

If(WildMatch([Item - Item Number], '403FC' , '401FC'), 'Reach',

If(WildMatch([Item - Item Number], '401XL' , '501XL' , '503XL' ), 'XL',

If(WildMatch([Item - Item Number], 'KITUS' , '3US' , '03167' , 'PRD-03146'), 'Advanced',

If(WildMatch([Item - Item Number], '00910' , 'NS2' , 'NS20' ), 'Classic',

'Unspecified'))))))

This expression is used to return revenue on the groupings, however, I would like to exclude "Unspecified" data from the expression entirely. 

Any suggestions?

Thanks!

[Anonymous]

just remove

, 'Unspecified'

and you'll get null() for  the rest...

[Anonymous · Accepted solution]

by the way, why do you use wildmatch() without wildcards?

I would suggest using applymap() instead...

[Anonymous]

Hi Robin,

Thank you very much for the response! That worked!