Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
philmywallet
Creator
Creator

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
sunny_talwar

May be this

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

View solution in original post

2 Replies
sunny_talwar

May be this

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

View solution in original post

philmywallet
Creator
Creator
Author

Perfect.  Thanks