topic Re: Changing column header color in QlikView

Changing column header color

Wed, 27 Mar 2013 13:07:05 GMT

Hello,

I was wondering if there was a way to change the background color for individual column headers? For example, I would like to make one column header blue and another black to distinguish both columns from each other. Thanks!

Kevin

Re: Changing column header color

Wed, 27 Mar 2013 13:23:41 GMT

Which Column headers are you talking about? Pivot Tabels or Normal Tables?

Re: Changing column header color

Wed, 27 Mar 2013 13:28:25 GMT

Hi Keshav,

It is a normal table. Currently when I go to change the background color for an individual column header, it changes the background color of all the column headers.

Re: Changing column header color

Gysbert_Wassenaar — Wed, 27 Mar 2013 13:31:40 GMT

You can't change the colors of the individual column labels. You can change the color of all of them together. You can change the color of individual cells for totals. And you can change the background color of individual columns. This will also override the color set for the totals cell. See the image below:

To change customize the cells first enable the option Always Show Design Menu Items on the Design tab of the user preferences window. Then in the chart right click the cell you want to customize and choose Custom Format Cell.

Re: Changing column header color

Wed, 27 Mar 2013 13:47:05 GMT

Hai K.Strunk4,

For changing tthe background colours of individual columns,

Settings->Userpreference->Designtab-> check always show design tabs and then go to the table and right click on the colum heading , you can see the list of options, in that chose custom format cell, their you can change the colurs

hope it helps for you

Regards

ramesh

Re: Changing column header color

Wed, 27 Mar 2013 13:47:50 GMT

Gysbert,

I appreciate your response. What I'm concerned with is the Column headers in yellow in your image. I have enabled the Always Show Design Menu Items but my problem still persists. Any ideas?

Re: Changing column header color

Wed, 27 Mar 2013 13:57:02 GMT

Ramesh,

Please see reply above. Any ideas?

Kevin

Re: Changing column header color

Sun, 08 Sep 2013 16:51:22 GMT

Hi,

Try to use Custom format cell.

Re: Changing column header color

Wed, 12 Mar 2014 15:21:45 GMT

Hi,

you can change the chart type in 'Pivot Table', the aspect doesn't change but you can set different colours for Dimension's header and for Expressions' headers.

Re: Changing column header color

antoniotiman — Wed, 12 Mar 2014 16:01:35 GMT

You select 'Segnali visivi' (after 'Grafic'. I have italian version) and choose 'Text'.

Regards

Re: Changing column header color

Fri, 30 Jan 2015 11:28:12 GMT

Hi Loredana,

Could you please suggest how to change colours on headers in pivot chart.

Thanks

Re: Changing column header color

reshmakala — Fri, 30 Jan 2015 18:38:54 GMT

Right click on the column header of the pivot table and select "Custom Format cell"... there change the background color.

Re: Changing column header color

Fri, 30 Jan 2015 19:13:52 GMT

Correct Reshma! This is a very straightforward way to change column color for headers on pivot tables.

Additionally I want to clarify that you have to apply the "Custom Format cell" separately for dimensions and expressions.

T.P.S.

Re: Changing column header color

Sat, 29 Aug 2015 11:41:52 GMT

Hi,

yes, it's possible to change the colour of particular headers in straight table, but it's a bit confusing to understand, but it works

See here to find the solution:

Regards, K

Re: Changing column header color

Anonymous — Wed, 07 Jun 2017 22:01:38 GMT

This seems in Qlik View.

Is it possible to set the header row color (background color) in Qlik Sense?

Any suggestion is appreciated!

Re: Changing column header color

divyanshi — Fri, 14 Jul 2017 06:13:40 GMT

but there is no option of "Custom Format Cell" by right-clicking on column header in qilksense??