Help - Set analysis and Background color (straight table)

Anonymous — Wed, 08 Mar 2017 10:03:40 GMT

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.

Re: Help - Set analysis and Background color (straight table)

ganeshsvm — Wed, 08 Mar 2017 10:57:40 GMT

HI,

You have to check an option in Presentation tab -> Suppress zero-values. This is will give you the desired results.

FYI - bg color exp doesn't make any effect to change in no. of rows to be aggregated in the chart.

Hope this helps.

-Ganesh

Re: Help - Set analysis and Background color (straight table)

simone_sacilott — Wed, 08 Mar 2017 11:32:17 GMT

Hi, I'm a co-worker of Giorgia, working on this problem.

Thanks for your reply, however we already tried to set that flag.

In fact, as you said, we too didn't expect the background colour to have an effect on the rows' aggregation, but we got this behaviour, as illustrated in the example.

Simone

topic Re: Help - Set analysis and Background color (straight table) in QlikView

Help - Set analysis and Background color (straight table)

Re: Help - Set analysis and Background color (straight table)

Re: Help - Set analysis and Background color (straight table)