Dimension Colour Background with a contain

[kfahri342]

Hi Qlikers,

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".

I have tried using this, however the "*" causes an error in the function.

=if(Status = "*Complete*", green(), black())

Any ideas?

Many Thanks

Kozan

[Digvijay_Singh · Accepted solution]

May be this -

if(Wildmatch(Status,'*Complete*'),green(),black())