Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
NenadV
Creator II
Creator II

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

in Qlikview please:

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

2024-04-23_14-16-27.jpg

 

Thank you

Labels (2)
1 Solution

Accepted Solutions
marcus_sommer

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.

marcus_sommer_0-1714062247330.png

 

View solution in original post

22 Replies
Clement15
Partner - Creator III
Partner - Creator III

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

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

Clement15_1-1713877597533.png

 

 

NenadV
Creator II
Creator II
Author

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
Partner - Creator III
Partner - Creator III

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
Creator II
Creator II
Author

I did. Thank you Clement 🙂

NenadV
Creator II
Creator II
Author

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
Creator II
Creator II
Author

Good tip. Thanks.

2024-04-25_11-11-08.jpg

 

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.