topic Re: Change color in pivot table header area in QlikView

Change color in pivot table header area

Wed, 14 Jan 2015 14:19:30 GMT

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!

Re: Change color in pivot table header area

Gysbert_Wassenaar — Fri, 16 Jan 2015 10:24:37 GMT

Set the Cell Background Color Transparency to 100%

Re: Change color in pivot table header area

Fri, 16 Jan 2015 11:02:45 GMT

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

Re: Change color in pivot table header area

Fri, 16 Jan 2015 11:19:27 GMT

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

Re: Change color in pivot table header area

Gysbert_Wassenaar — Fri, 16 Jan 2015 11:25:40 GMT

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.

Re: Change color in pivot table header area

Fri, 16 Jan 2015 11:27:01 GMT

That's a nice workaround, thanks!