Discussion Board for collaboration on QlikView Scripting.
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.
Go to Solution.
May be this
If(SubStringCount(Concat(DISTINCT '|' & Name & '|'), '|VACANT|') = 1, RGB(255,0,0))