Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

rociotrevial
Contributor

How can I change background color to a header in a Pivot Table?

How can I change background color to a header in a Pivot Table, but only some columns header?

This columns are expressions and I need change background color in some columns header not in all.

For example, I have a Pivot Table like this:

CountrySalesCost
Mexico345,456,890123,678,543
USA890,223,112689,321,890
Japan789,478,900567,908,145

And I need distinct background color in the columns header of the expressions (Sales in Yellow and Cost in Green) , like this:

CountrySalesCost
Mexico345,456,890123,678,543
USA890,223,112689,321,890
Japan789,478,900567,908,145

How can I do it?

I need your help!!!

Thanks

10 Replies
Not applicable

Re: How can I change background color to a header in a Pivot Table?

Hi,

As far as I know wyou can only achieve that using some visualization tricks.

Using the layer level you can  overlap the object and then usings their respective color properties, you can get an aproximate color custom solution of the pivot or straight tables headers.

Check the file attached and see if it satisfy your need

Cheers

Sokkorn
Honored Contributor

Re: How can I change background color to a header in a Pivot Table?

Hi rociotrevial,

This post http://community.qlik.com/message/261681 may do this job. Let me know once you tested it.

Regards,

Sokkorn

rank_nandha
Contributor II

Re: How can I change background color to a header in a Pivot Table?

Hi Rocio,

This is ver y easy

Right click on chart -> "Custome format cell" and chnage the color for that particular cell BG.

Regards,

Nandha

rociotrevial
Contributor

Re: How can I change background color to a header in a Pivot Table?

Hi Everyone,

The problem is when rightclicking and selecting "Custom format cell" the dropbox "Apply change to" only gives the option "All dimensions".

rociotrevial
Contributor

Re: How can I change background color to a header in a Pivot Table?

Hi Everyone,

The problem is when rightclicking and selecting "Custom format cell" the dropbox "Apply change to" only gives the option "All dimensions".

rociotrevial
Contributor

Re: How can I change background color to a header in a Pivot Table?

Hi Everyone,

The problem is when rightclicking and selecting "Custom format cell" the dropbox "Apply change to" only gives the option "All dimensions".

rociotrevial
Contributor

Re: How can I change background color to a header in a Pivot Table?

Hi Everyone,

The problem is when rightclicking and selecting "Custom format cell" the dropbox "Apply change to" only gives the option "All dimensions".

rank_nandha
Contributor II

Re: How can I change background color to a header in a Pivot Table?

Can you explain clearyl????

er_mohit
Honored Contributor II

Re: How can I change background color to a header in a Pivot Table?

see the attached file hope it helps you

http://community.qlik.com/message/207492#207492

Community Browser