topic Re: Dimension Colour Background with a contain in QlikView https://community.qlik.com/t5/QlikView/Dimension-Colour-Background-with-a-contain/m-p/57478#M9551 <HTML><HEAD></HEAD><BODY><P>May be this - </P><P>if(Wildmatch(Status,'*Complete*'),green(),black())</P></BODY></HTML> Tue, 20 Mar 2018 13:39:06 GMT Digvijay_Singh 2018-03-20T13:39:06Z Dimension Colour Background with a contain https://community.qlik.com/t5/QlikView/Dimension-Colour-Background-with-a-contain/m-p/57477#M9550 <HTML><HEAD></HEAD><BODY><P>Hi Qlikers,</P><P></P><P>I have a pivot table where I would like to change the background of the cell dependant on the value. However, as the values are quite interchangeable, I need to be able to tell Qlikview for example to change the cell green if the value contains the word "Complete".</P><P></P><P>I have tried using this, however the "*" causes an error in the function.</P><P></P><P>=if(Status = "*Complete*", green(), black())</P><P></P><P>Any ideas?</P><P>Many Thanks</P><P>Kozan</P></BODY></HTML> Tue, 20 Mar 2018 13:29:17 GMT https://community.qlik.com/t5/QlikView/Dimension-Colour-Background-with-a-contain/m-p/57477#M9550 kfahri342 2018-03-20T13:29:17Z Re: Dimension Colour Background with a contain https://community.qlik.com/t5/QlikView/Dimension-Colour-Background-with-a-contain/m-p/57478#M9551 <HTML><HEAD></HEAD><BODY><P>May be this - </P><P>if(Wildmatch(Status,'*Complete*'),green(),black())</P></BODY></HTML> Tue, 20 Mar 2018 13:39:06 GMT https://community.qlik.com/t5/QlikView/Dimension-Colour-Background-with-a-contain/m-p/57478#M9551 Digvijay_Singh 2018-03-20T13:39:06Z