Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

shinnickr
Contributor II

Grey Column Header in Pivot Table

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.

Qlik Column Help.PNG

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

Any help would be appreciated!  Thank you.

1 Solution

Accepted Solutions
Employee
Employee

Re: Grey Column Header in Pivot Table

Maybe you can put a blued textbox over that space

View solution in original post

8 Replies
Employee
Employee

Re: Grey Column Header in Pivot Table

It´s a dimension that has been pivoted

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

shinnickr
Contributor II

Re: Grey Column Header in Pivot Table

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

Qlik CFC Help.PNG

Employee
Employee

Re: Grey Column Header in Pivot Table

Maybe you can put a blued textbox over that space

View solution in original post

shinnickr
Contributor II

Re: Grey Column Header in Pivot Table

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

Partner
Partner

Re: Grey Column Header in Pivot Table

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.

shinnickr
Contributor II

Re: Grey Column Header in Pivot Table

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.

Partner
Partner

Re: Grey Column Header in Pivot Table

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.

shinnickr
Contributor II

Re: Grey Column Header in Pivot Table

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