topic Re: header row background color in pivot table in QlikView

header row background color in pivot table

sonikajain — Mon, 07 May 2012 13:29:55 GMT

Hi all,

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

Sonika

header row background color in pivot table

mphekin12 — Mon, 07 May 2012 13:38:30 GMT

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!

Re: header row background color in pivot table

vincent_ardiet — Mon, 07 May 2012 13:44:55 GMT

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

header row background color in pivot table

Mon, 07 May 2012 14:04:29 GMT

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

header row background color in pivot table

sonikajain — Mon, 07 May 2012 14:38:10 GMT

thanks , it worked from the design pane

Re: header row background color in pivot table

Fri, 25 Jan 2013 13:04:45 GMT

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