Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
kfahri342
New Contributor III

Dimension Colour Background with a contain

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

1 Solution

Accepted Solutions
Digvijay_Singh
Honored Contributor III

Re: Dimension Colour Background with a contain

May be this -

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

View solution in original post

1 Reply
Digvijay_Singh
Honored Contributor III

Re: Dimension Colour Background with a contain

May be this -

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

View solution in original post