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

[Clement15]

Hello, you can use this type of function here. This should answer your question

if(Above([Nombre de joueur])>[Nombre de joueur],green())

[NenadV]

merci, but I don't speak French.

This doesn't work in a Straight Table in QlikView expression's Background color property if(above(Price) > Price, green())

[marcus_sommer]

Maybe adding an aggregation will change the results, means:

if(above(sum(Price)) > sum(Price), green())

[Clement15]

In the function  [Nombre de joueur] is a measure, not the name of a field. You must replace it with the measure you want.

[NenadV]

I did. Thank you Clement 🙂

[NenadV]

Thanks Marcus. This doesn't solve the issue

[marcus_sommer]

You may approach a possible solution by adding parts within the normal expressions, like:

above(YourExpression)

Now you will see the results and comprehend what's going on and then adjusting it.

[NenadV]

Good tip. Thanks.

it just doesn't work 

[marcus_sommer]

Depending on the used number of dimensions you may need to add: above(TOTAL YourExpression)

Beside this make sure that YourExpression itself is working and that it relates to an expression and not to a dimension.