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: 
Not applicable

Conditonal colours

=IF(Market='EMEA*',RGB(141,90,162),)

wildcarding the MARKET field doesn't seem to work when I am trying to conditionally colour some bars in my chart.

What i need to do is colour all values which start with 'EMEA'. I don't want to have to do a nested if statement for all possible values.

How can I amend my formula to do this?

1 Solution

Accepted Solutions
jerem1234
Specialist II
Specialist II

if(wildmatch(Market, 'EMEA*'), RGB(141,90,162))

Hope this helps!

View solution in original post

1 Reply
jerem1234
Specialist II
Specialist II

if(wildmatch(Market, 'EMEA*'), RGB(141,90,162))

Hope this helps!