Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
Valued Contributor II

Re: Conditonal colours

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

Hope this helps!

1 Reply
jerem1234
Valued Contributor II

Re: Conditonal colours

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

Hope this helps!

Community Browser