I'm going under the assumpition that your RTT_Value field is a dimension. Go to the dimensions tab click on the "+" sign next to your field and use an expression like this for your background color.
=If( Value >= 18, LightRed(), White() )
See attached example.
colorful pivot table.qvw 136.8 K
Thank you Oscar for your reply, but your example appears to work due to the fact that Qlikview is not regarding the 0 as missing.
When I pull the data in from a spreadsheet, Qlikvire regards the blanks as missing, ands its these ones that I can get highlighted.
I've attached my document which may help.
Test Doc.qvw 221.5 K
Thank you for your responses, I have just read a post which I think answers my question.
Apparently you can't colour the background of a cell that has a missing value:
To get my counts I am counting an ID field, is there a away to replace a missing count with a value of 0?
My expression is this:
I've tried this but it didn't work:
Any ideas would be greatly appreciated