Discussion Board for collaboration on QlikView Scripting.
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?
Go to Solution.
if(wildmatch(Market, 'EMEA*'), RGB(141,90,162))
Hope this helps!