Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
rociotrevial
Creator
Creator

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

hi try this

1.jpg

2. Right click on chart -> "Custom format cell"

2.jpg

hope this helps you.