Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

philmywallet
New Contributor III

Wildmatch Conditional formatting

Hi

I have created a concatenated field to show names.  See below :

Concat(Name,Chr(10))

How do I change the background colour if the Concatenated cell contains 'VACANT'

Any help appreciated.

Regards

Phil

1 Solution

Accepted Solutions
MVP
MVP

Re: Wilmatch Conditional formatting

May be this

If(SubStringCount(Concat(DISTINCT '|' & Name & '|'), '|VACANT|') = 1, RGB(255,0,0))

2 Replies
MVP
MVP

Re: Wilmatch Conditional formatting

May be this

If(SubStringCount(Concat(DISTINCT '|' & Name & '|'), '|VACANT|') = 1, RGB(255,0,0))

philmywallet
New Contributor III

Re: Wilmatch Conditional formatting

Perfect.  Thanks

Community Browser