topic Re: Grey Column Header in Pivot Table in QlikView

Grey Column Header in Pivot Table

shinnickr — Wed, 25 Nov 2020 16:16:04 GMT

Hi there,

I'm working on a pivot table and for some reason there is a column header that is grey and I can't figure out how to change it. I've set the style as "Pyjama Blue" but the end column just stays as grey. It seems like it's some vestigial cell because when I turn the 'Cell Background Color Transparency' and 'Cell Border Transparency' to 100%, it goes away. But I can't figure out how to change the color.

The column I've circle is the one that I can't figure out how to format.

Any help would be appreciated! Thank you.

Re: Grey Column Header in Pivot Table

Clever_Anjos — Thu, 28 Sep 2017 17:46:44 GMT

It´s a dimension that has been pivoted

You can change it´s color using Control G and right clik with "Custom Format Cell"

Re: Grey Column Header in Pivot Table

shinnickr — Thu, 28 Sep 2017 17:51:13 GMT

I just tried that and it shows that is blue already in the Custom Format Cell box, but is still grey.

Re: Grey Column Header in Pivot Table

Clever_Anjos — Thu, 28 Sep 2017 17:56:36 GMT

Maybe you can put a blued textbox over that space

Re: Grey Column Header in Pivot Table

shinnickr — Thu, 28 Sep 2017 18:08:06 GMT

Haha that would be an easier fix. I'm just not sure I could get it to look exactly how it needs to.

Re: Grey Column Header in Pivot Table

krishnacbe — Thu, 28 Sep 2017 18:09:39 GMT

Do you need Separate color for Dimension and Expression? I tried to use same color and able to color the Pivoted Column header as well. If possible attach the dashboard, will check.

Re: Grey Column Header in Pivot Table

shinnickr — Thu, 28 Sep 2017 18:18:45 GMT

I don't think I need a separate color for dimension and expression. Unfortunately I'm unable to attach the dashboard as it has sensitive information.

Re: Grey Column Header in Pivot Table

krishnacbe — Thu, 28 Sep 2017 18:39:02 GMT

Find the attached file. I am able to change the color with Custom Formatting. Might be change the style of the Pivot table and try to custom Color Change.

Re: Grey Column Header in Pivot Table

shinnickr — Thu, 28 Sep 2017 18:57:51 GMT

Huh, see in yours when I choose Custom Format Cell I can see the correct color that the cell is. When I try on mine it shows the background color is blue even though the actual cell is grey.

Thanks for the help though. I think I'm just going to end up putting a blue box covering it like Clever Anjos suggested