Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
by the way, why do you use wildmatch() without wildcards?
I would suggest using applymap() instead...
just remove
, 'Unspecified'
and you'll get null() for the rest...
by the way, why do you use wildmatch() without wildcards?
I would suggest using applymap() instead...
Hi Robin,
Thank you very much for the response! That worked!