topic Re: How to set a different background color based on value comparison with the row above in QlikView

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

NenadV — Tue, 23 Apr 2024 12:24:04 GMT

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

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

Clement15 — Tue, 23 Apr 2024 13:06:49 GMT

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

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

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

NenadV — Tue, 23 Apr 2024 14:46:19 GMT

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())

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

marcus_sommer — Tue, 23 Apr 2024 14:51:01 GMT

Maybe adding an aggregation will change the results, means:

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

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

Clement15 — Tue, 23 Apr 2024 14:55:17 GMT

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

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

NenadV — Tue, 23 Apr 2024 14:57:48 GMT

I did. Thank you Clement 🙂

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

NenadV — Tue, 23 Apr 2024 15:00:37 GMT

Thanks Marcus. This doesn't solve the issue

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

marcus_sommer — Tue, 23 Apr 2024 15:07:17 GMT

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.

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

NenadV — Thu, 25 Apr 2024 09:13:14 GMT

Good tip. Thanks.

it just doesn't work

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

marcus_sommer — Thu, 25 Apr 2024 09:41:08 GMT

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.

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

NenadV — Thu, 25 Apr 2024 10:38:08 GMT

That doesn't make sense. Why such a basic and simple function does not work.

It' bout only comparing values in two consecutive lines and coloring it differently to emphasize it?

Is it possible that this only doesn't work in QlikView?

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

NenadV — Thu, 25 Apr 2024 10:44:37 GMT

Straight table with plain cost numbers. Nothing fancy!

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

marcus_sommer — Thu, 25 Apr 2024 10:53:59 GMT

Of course it will work - if not anything is wrong with your expressions. Like above mentioned make sure that they are working and not returning NULL like in your example screenshot. Here a quick check with my data:

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

NenadV — Thu, 25 Apr 2024 11:27:31 GMT

Why this works only if you have up to and including 2 dimensions?

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

marcus_sommer — Thu, 25 Apr 2024 11:36:22 GMT

If there are multiple dimensions you may need a TOTAL statement with the above() and/or also wrapping the above() with an aggr(). At first implement the interrecord-logic directly in the chart to see if it returned valid and the expected values for each cell - and then a color-comparing within the attribute-expressions should be also working.

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

NenadV — Thu, 25 Apr 2024 11:41:11 GMT

Thanks Marcus. In this simple request there is nothing to sum up, it is only to show if the value in one row is different from the value in the row just above. Can't be simpler

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

marcus_sommer — Thu, 25 Apr 2024 11:45:15 GMT

That's never true - because everything is and must be an aggregation and if none is explicitly applied Qlik takes only() and as far as if there is more as single value available the result will be NULL.

The Aggregation Scope - Qlik Community - 1467321

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

NenadV — Thu, 25 Apr 2024 12:52:53 GMT

Then, if there is nothing to sum up and if there is only one value per line/row using the max() function should be ok. Correct?

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

NenadV — Thu, 25 Apr 2024 12:56:45 GMT

and it doesn't work with more than 2 dimensions 😞

Text Color if(max(X) > above(max(X)), lightred())

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

marcus_sommer — Thu, 25 Apr 2024 13:29:49 GMT

Skip at first the condition and apply these 3 expressions:

max(X)
above(max(X))
above(TOTAL max(X))

does they return always they expected values?