this is in qlik 12, if it matters. I have a hugely long/complex expression, in a pivot table, labeled A. I want to change the background color of the cell, based on the value of this expression, to red, yellow or green. all i can find, searching here, is how to change color based on the value of a variable or based on the value of a dimension. this is neither. do i really have to put :
if (HUGEEXPRESSION)>-.1, $vgreen
i was hoping i could do something like :
If (A>.1), $vgreen
but that doesn't work. is this possible?