Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I am trying to conditionally format the total row in my table.
I have a table in QLIK SENSE, and I want to color the TOTAL row in it. I have tried with function.
Isnull(row()) and dimensionality().
and also use other expression for achieving Total color.
my expression
= If(Even(RowNo(TOTAL)) , RGB(203, 209, 225), RGB(231,234,241))
but none of these seems to work.
my requirement is that total should be in red when values are in -ve and should be in green when values are in +ve.
For e.g The value of Total or -90.4% should be in Red.
Pls find attached snapshot for your reference.
Can someone help me in this?
@aamer007 share your qvf file showing that it is not working