Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sonikajain
Partner - Contributor
Partner - Contributor

header row background color in pivot table

Hi all,

Please advise on changing the background color and formatting to BOLD for header row in a pivot table.

Sonika

1 Solution

Accepted Solutions
vincent_ardiet
Specialist
Specialist

Hi Sonika,

First go to the User Preferences, and choose "Always Show Design Menu Items" in the Design tab.

Then, if you right click on your header, you will have the "Custom Format Cell" entry in the contextual menu.

You will be abble to fine tune the colors of your cells.

Regards,

Vincent

View solution in original post

5 Replies
mphekin12
Specialist
Specialist

Sonika,

Go to the 'Visual Cues' tab of the Properties of the Pivot Table and check the 'Bold' check box and change the Background Color in the 'Text' row.  You will need to do this for each expression in the Pivot Table.

I hope this helps!

vincent_ardiet
Specialist
Specialist

Hi Sonika,

First go to the User Preferences, and choose "Always Show Design Menu Items" in the Design tab.

Then, if you right click on your header, you will have the "Custom Format Cell" entry in the contextual menu.

You will be abble to fine tune the colors of your cells.

Regards,

Vincent

Not applicable

Hi Sonika,

You can also go to properties of the chart and expand all dimensions and expression and then write Expression to change  Background Color, Text format, Text color if you are not able to fulfill your requirement with the solution give by Vincent.

Hope this help,

Anosh

sonikajain
Partner - Contributor
Partner - Contributor
Author

thanks , it worked from the design pane

Not applicable

Need to populate one list box depending upon the selection of other ? Can anyone help on this ?