Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
Straight table with plain cost numbers. Nothing fancy!
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:
Why this works only if you have up to and including 2 dimensions?
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.
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
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.
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?
and it doesn't work with more than 2 dimensions 😞
Text Color if(max(X) > above(max(X)), lightred())
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?