Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Contributor III
Contributor III

try this,

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

 

View solution in original post

3 Replies
Highlighted
Contributor III
Contributor III

try this,

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

 

View solution in original post

Highlighted
Partner
Partner

Hi

try this

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

Thanks

Highlighted
Contributor
Contributor

Thank you 🙂 was a very simple solution it seems