How to set a different background color based on value comparison with the row above

[NenadV]

in Qlikview please:

For example, if the value in the 2nd row is lower than in the row above to be colored in green.

Thank you

[NenadV]

they do, but total is taking into account all lines, isn't it?

TOTAL

If the table is one-dimensional or if the qualifier TOTAL is used as argument, the current column segment is always equal to the entire column.

[marcus_sommer · Accepted solution]

TOTAL ignores all respectively certain dimensions (not above() or rowno() but a sum() or max() have further TOTAL options).

For your use-case it will work with TOTAL within the attribut-expressions as well as as direct expressions - at least in your example it does.