Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 🙂
try this,
if(wildmatch([Value],'*Suspended*' ,'*Unfit*', '*Removed*'),red())
try this,
if(wildmatch([Value],'*Suspended*' ,'*Unfit*', '*Removed*'),red())
Hi
try this
if(wildmatch([Value],'*Suspended*' ,'*Unfit*' , '*Removed*')<>0,red())
Thanks
Thank you 🙂 was a very simple solution it seems