Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
analystdude96
Contributor
Contributor

Multiple wildmatch in colour expression

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 🙂 

 

Labels (1)
1 Solution

Accepted Solutions
PunamWagh
Contributor III
Contributor III

try this,

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

 

View solution in original post

3 Replies
PunamWagh
Contributor III
Contributor III

try this,

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

 

Kashyap_R
Partner - Specialist
Partner - Specialist

Hi

try this

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

Thanks

Thanks and Regards
Kashyap.R
analystdude96
Contributor
Contributor
Author

Thank you 🙂 was a very simple solution it seems