Discussion Board for collaboration related to QlikView App Development.
Hello All -
I'm using Expression Attributes to conditionally color columns in a straight table. It's a simple greater than or less than 'If' statement (>20, green or <5, red). Is there a way to not color the expression total?
I'm using v12.1 SR7.
This was so close! the <> 0 didn't work, so I tried > 0 and, bingo, no more color.
View solution in original post
The total row rowno() is 0 , so add another condition to check for the total row as below
if ( expression>20,green(),
It should works with
=if(Dimensionality()=1,if(sum([Group1 trips])>20,green(),if( sum([Group1 trips])<5,red())),Black())
Thank you for the suggestion, but it unfortunately removed the color completely.
I have tried with a sample and it works. Try to add a dimensionnality() expression for see what it returns.