Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

coloring in pivot table with nestled column

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

3 Replies
morgankejerhag
Partner - Creator III
Partner - Creator III

Like this? The color setting is on the expression.

Not applicable
Author

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

morgankejerhag
Partner - Creator III
Partner - Creator III

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.