Discussion Board for collaboration related to QlikView App Development.
I have created a concatenated field to show names. See below :
How do I change the background colour if the Concatenated cell contains 'VACANT'
Any help appreciated.
May be this
If(SubStringCount(Concat(DISTINCT '|' & Name & '|'), '|VACANT|') = 1, RGB(255,0,0))
View solution in original post