topic Re: Column Header color changes in pivot Table. in QlikView

Column Header color changes in pivot Table.

anuradhaa — Mon, 27 Jan 2014 08:22:20 GMT

Hi,

I want to change column header color in my pivot table. But i don't know how to do it. Then i select current style and done some editing in custom format cells.

Some how it works but i know this is not the correct way?

I can't change column header raw in custom cell format and i only can change other raws.

Now i have another question,

in this attached picture there is a gray box and black lines, i need to change them.

please tell me how to change them.

Thanks

Re: Column Header color changes in pivot Table.

alexandros17 — Mon, 27 Jan 2014 08:37:52 GMT

Right click on the poivot table, the select in the popup menu the item "Custom format cell" then use it to personalize cells

Hope it helps

P.S. if the voice is greyed then in document setting -> document properties -> general select styling mode -> advanced

Re: Column Header color changes in pivot Table.

rustyfishbones — Mon, 27 Jan 2014 08:40:43 GMT

Right Click in the Chart area of your pivot table and Choose Custom Format Cell

Re: Column Header color changes in pivot Table.

anuradhaa — Mon, 27 Jan 2014 08:41:16 GMT

No, that doesn't work.

Could you please tell how to change top raw using that settings. It doesn't work for top raw.

Thanks

Re: Column Header color changes in pivot Table.

anuradhaa — Mon, 27 Jan 2014 08:42:10 GMT

yes, i know we can do it using that, but that doesn't work for top raw.

Thanks for your reply

Re: Column Header color changes in pivot Table.

rustyfishbones — Mon, 27 Jan 2014 08:45:22 GMT

Check the Style Tab, maybe you have the Cell transparency set to 100%

Re: Column Header color changes in pivot Table.

alexandros17 — Mon, 27 Jan 2014 08:46:40 GMT

Click on the header (in the cell you want to change, select the voice "Custom format cell" and use background color, it works ...

Re: Re: Column Header color changes in pivot Table.

anuradhaa — Mon, 27 Jan 2014 08:50:53 GMT

No, It doesn't work for the top raw.

see attached,

Re: Column Header color changes in pivot Table.

rustyfishbones — Mon, 27 Jan 2014 08:58:43 GMT

It does not work because that's a dimension, not the top row

So in the Dimension, Click on the + button to change the background color

Re: Column Header color changes in pivot Table.

Mon, 27 Jan 2014 09:10:16 GMT

It is working....please check again

You may have fixed color for particular expression or dimension in their background color...

Re: Re: Column Header color changes in pivot Table.

anuradhaa — Mon, 27 Jan 2014 09:16:52 GMT

Thanks,

But problem i have is The "Gray Box". That is empty. also i don't know how to remove borders.

Re: Column Header color changes in pivot Table.

Tue, 20 May 2014 20:57:44 GMT

I'm having the same issue, and Anuradha is correct, it is not resolved using neither Custom Format Cell nor Dimension Background Color.

Here's my own example, attached.

Re: Column Header color changes in pivot Table.

anilet123 — Mon, 12 Oct 2015 17:44:31 GMT

Hi,

Whether the issue fixed ? I am also facing the same problem & above solutions are not working. can anyone provide the right approach pls ..

Regards,

Anilet

Re: Column Header color changes in pivot Table.

settu_periasamy — Tue, 13 Oct 2015 03:07:05 GMT

Hi,

i think, we can't cant change that color in pivot table (because your dimension moved to the row)

May be you can try with Cell Background Transparency as 100% in Style tab.

Create the text box,give the color, put this in the top left position of your pivot table.

Change color in pivot table header area

Re: Column Header color changes in pivot Table.

Digvijay_Singh — Tue, 13 Oct 2015 05:09:27 GMT

Not sure but I found that I could change color of all sections of pivot table using Custom format cell. See the image below-