topic table header colors in QlikView

table header colors

srujanaponnuru — Wed, 25 Nov 2020 16:16:04 GMT

hi,

I have created a straight table and I need to color each column different color in that table. Please suggest.

Regards

Srujana

Re: table header colors

arulsettu — Wed, 07 Sep 2016 06:14:36 GMT

try this

right click the cell you want to color. then select format custom cell. there you can choose custom color.

Re: table header colors

srujanaponnuru — Wed, 07 Sep 2016 06:16:49 GMT

yes I have done that. but its coloring all the columns the same color.

my requirement is as follows:

I have one header as Investment and another as maintain. so for investment column cell I need to color as green, then maintain as red.

please help.

Re: table header colors

soloeeeoff — Wed, 07 Sep 2016 06:22:35 GMT

Like this ?

Re: table header colors

Wed, 07 Sep 2016 06:56:23 GMT

As shown in picture. Hope it helps.

Re: table header colors

srujanaponnuru — Wed, 07 Sep 2016 07:03:02 GMT

i haven't received any picture. please post it again

Re: table header colors

Anonymous — Wed, 07 Sep 2016 07:05:37 GMT

goto your Dimension and define Background colour

if (DIm='A', rgb(128,0,0),

if (Dim='B', rgb(255,0,0),....

Re: table header colors

srujanaponnuru — Wed, 07 Sep 2016 07:09:14 GMT

thank you.

But I need to color only that column header cell not all the cells of that particular column.

example:

YEAR	INVESTMENT	MAINTAIN	CONTAIN	LIFE SUPPORT
2015	45	215	98	40
2016	45	215	99	32
2017	41	212	90	23
2018	36	206	81	34
2019	34	207	80	17
2020	34	207	79	12
2021	34	207	75	13
2022	34	207	75	9

Re: table header colors

saimahasan — Wed, 07 Sep 2016 07:52:36 GMT

I think Qlikview has this loophole wherein we cannot colour each individual dimension header with a different color..

Rather you can color each dimension values with a different color.

Re: table header colors

vikasmahajan — Wed, 07 Sep 2016 08:50:28 GMT

Click on Grid Design -> Right Click Properties -> Select Format -> As required you can give color's to headings

Vikas.

Re: table header colors

srujanaponnuru — Wed, 07 Sep 2016 09:19:45 GMT

Hi vikas,

Where is grid design ?

Re: table header colors

Anonymous — Wed, 07 Sep 2016 09:46:43 GMT

Design Grid is in Tool bar next to Format Painter Tool. If you want custom color you need to enable Grid Mode then only Custom Format Cell will enable. But if you apply color for dimension it will impact all dimensions in the table.

Hope it helps

Re: table header colors

agomes1971 — Wed, 07 Sep 2016 10:04:23 GMT

Hi,

please see this

header row background color in pivot table

HTH

André Gomes

Re: table header colors

Anil_Babu_Samineni — Wed, 07 Sep 2016 10:19:39 GMT

Simply press shortcut to get Grid - Ctrl + G (But, you have problem with headers) - I don't think so is that is possible in qlikview?

Re: table header colors

srujanaponnuru — Wed, 07 Sep 2016 10:22:13 GMT

yes, I am not getting. I tried all the possible ways. thank u

Re: table header colors

ashfaq_haseeb — Wed, 07 Sep 2016 10:28:36 GMT

I think possible for all Header, Not Individually

Go to Setting --> user preference --> Design Tab --> Select Always show Design menu items.

Then right click on cell you want to highlight and select Custom format cell. --> apply your required formatting here.

Hope it helps.

Regards

ASHFAQ

Re: table header colors

srujanaponnuru — Wed, 07 Sep 2016 10:34:22 GMT

yes, it is possible for all the header columns single color but not individually different colors.

the one option I have done is I created a small text boxes and colored according my requirement and pasted and highlighted on those headers like below:

is there any other way to adjust these text boxes in a proper manner ?

Re: table header colors

Anil_Babu_Samineni — Wed, 07 Sep 2016 10:35:36 GMT

Ashfaq, Only one way as a i know. But, I didn't find. If you find any solution can you please create one Straight / Pivot table with his rek and share that file. That's really useful for me as well..

Re: table header colors

soloeeeoff — Wed, 07 Sep 2016 11:16:32 GMT

Like this ?

Re: table header colors

vikasmahajan — Thu, 08 Sep 2016 04:51:44 GMT

We can change column headers Re: Color only particular column header in a straight table

Find attached picture which show you how to activate grid and change the color's of headers it is possible in qlik.,

Thanks

Vikas