Multiple wildmatch in colour expression

[analystdude96]

Hi everyone,

New to Qliksense and picking it up pretty well but come across something that has stumped me. 

I want to set a background colour depending on what the data is e.g. 

=if(wildmatch([Value],'*Suspended*')=1,red()) - this works fine. 

But I need it to work for multiple wildmatch conditions, such as: 

=if(wildmatch([Value],'*Suspended*' or '*Unfit*' or '*Removed*')=1,red())

Expression editor does not say that there are any errors but it is not working and now does not background fill anything at all. 

Any help much appreciated 🙂 

[PunamWagh · Accepted solution]

try this,

if(wildmatch([Value],'*Suspended*' ,'*Unfit*', '*Removed*'),red())

[Kashyap_R]

Hi

try this

if(wildmatch([Value],'*Suspended*' ,'*Unfit*' , '*Removed*')<>0,red())

Thanks

[analystdude96]

Thank you 🙂 was a very simple solution it seems