Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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
Partner - Champion III
Partner - Champion III

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
Partner - Champion III
Partner - Champion III

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!