Hi all,
We are using a straight table to show some data. Using Set Analysis, we filter out rows that don’t meet a certain condition. At the same time, we colour the background of the other cells, checking a condition between adjacent rows using the Above/Below functions (in short, we check a condition on a column between consecutive rows). Our problem is that the colouration works, and the value of the set analysis’ expression correctly sets the value to zero in the rows to be suppressed, however these rows are not and are showed instead.
A simple example of this behaviour is the following: given the table
PROVA:
LOAD *
INLINE [
A, B
10, 20
10, 40
20, 40
];
And the set analysis condition “A=10”, we colour the background of the B column if the row above has the value 10 in the A column (the expression is: IF(Above(A)=10,Yellow())).
If we apply only the set analysis the result is shown on figure 1 (Immagine1.jpg)
The expression column is defined as Sum({$ < A={10} >} 1).
When we introduce the background coloration [condition IF(Above(A)=10,Yellow()) in the B column], we get the results you can see in Immagine2.jpg.
The background colour is correct, and so are the values in the expression column. However, the last row shouldn’t be shown, but suppressed because it correctly has a zero in the expression column.
How can we work around this problem? How can we supress the last unwanted row?
Thank you in advance.
