topic Conditonal colours in QlikView https://community.qlik.com/t5/QlikView/Conditonal-colours/m-p/709197#M675982 <HTML><HEAD></HEAD><BODY><P>=IF(Market='EMEA*',RGB(141,90,162),)</P><P></P><P>wildcarding the MARKET field doesn't seem to work when I am trying to conditionally colour some bars in my chart. </P><P></P><P>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.</P><P></P><P>How can I amend my formula to do this?</P></BODY></HTML> Thu, 03 Jul 2014 15:26:34 GMT 2014-07-03T15:26:34Z Conditonal colours https://community.qlik.com/t5/QlikView/Conditonal-colours/m-p/709197#M675982 <HTML><HEAD></HEAD><BODY><P>=IF(Market='EMEA*',RGB(141,90,162),)</P><P></P><P>wildcarding the MARKET field doesn't seem to work when I am trying to conditionally colour some bars in my chart. </P><P></P><P>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.</P><P></P><P>How can I amend my formula to do this?</P></BODY></HTML> Thu, 03 Jul 2014 15:26:34 GMT https://community.qlik.com/t5/QlikView/Conditonal-colours/m-p/709197#M675982 2014-07-03T15:26:34Z Re: Conditonal colours https://community.qlik.com/t5/QlikView/Conditonal-colours/m-p/709198#M675983 <HTML><HEAD></HEAD><BODY><P>if(wildmatch(Market, 'EMEA*'), <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">RGB(141,90,162)</SPAN>)</P><P></P><P>Hope this helps!</P></BODY></HTML> Thu, 03 Jul 2014 15:27:57 GMT https://community.qlik.com/t5/QlikView/Conditonal-colours/m-p/709198#M675983 jerem1234 2014-07-03T15:27:57Z