Discussion board where members can get started with Qlik Sense.
i have a problem with the coloring the field when the previous field value is the same.
a123 -------> i need to add a background in this field
c222 -------> i need to add a background in this field
If possible, I need it in the expression.
Go to Solution.
did you check this?
Color previous row in straight table if the same | Qlik Community
I think the function below will help you
"Below() evaluates an expression at a row below the current row within a column segment in a table"
=if(dim=below(dim,1), backgroundColor, noBackgroundColor)
it works perfect, I needed to use TOTAL.
The expression is : =if( dim = below(TOTAL dim), backgroundColor, noBackgroundColor)