Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Change color in pivot table header area

Hello,

I have difficult time changing the color of the top left area in pivot table. Please see screenshot: http://screencast.com/t/gPtgN4Ygpgla

It seems that "Custom Format cell" doesn't work here, please see screenshot: http://screencast.com/t/riTrrsyar

I also tried using different styles but that didn't help either.

Does anyone have an idea how to change color or maybe make transparent that gray area?

Thanks!

5 Replies
Gysbert_Wassenaar

Set the Cell Background Color Transparency to 100%

comm148379.png


talk is cheap, supply exceeds demand
Not applicable
Author

Tried that but only made transparent rest of columns but not the one I needed. Although I did select this particular column.

qv pivot.jpg

Not applicable
Author

This also doesn't help as it makes all table cells transparent whereas I need to color the columns in the table

Gysbert_Wassenaar

Put a text box on top of the left corner of the pivot table. Resize it so it fits, give it any color you like and make sure it is in a higher layer than the pivot table.


talk is cheap, supply exceeds demand
Not applicable
Author

That's a nice workaround, thanks!