topic Re: coloring in pivot table with nestled column in QlikView

coloring in pivot table with nestled column

Sun, 16 Nov 2014 18:11:48 GMT

Hi.

I have a pivot report with nestled columns (see picture). I have been able to color total rows but not been able to format the nestled

columns (see attachment)

Mikael

Re: coloring in pivot table with nestled column

morgankejerhag — Sun, 16 Nov 2014 18:51:08 GMT

Like this? The color setting is on the expression.

Re: coloring in pivot table with nestled column

Sun, 16 Nov 2014 19:19:27 GMT

Hi Morgon.

Been able to set the coloring on row and measure. But problem to coloring the space between row and column (see picture). The problem is that I have nestled columns ?

Mikael (-;

Re: coloring in pivot table with nestled column

morgankejerhag — Sun, 16 Nov 2014 19:53:23 GMT

Ah, Mikael, didn't notice that it was you asking first

If setting a background color on the presentation tab the column with labels is not filled.

With custom cell format it is possible to set a colour to the column (but only for all values)

If setting Cell Background Color Transparency on Style to 100% it would be possible to have another colored object behind the table, but is it work the extra trouble?

I don't find any good way neither, so it is interesting to see if anyone else knows.