topic Color only particular column header in a straight table in QlikView

Color only particular column header in a straight table

udaya_kumar — Wed, 02 Jan 2013 09:38:06 GMT

Hi,

I have a straight table with one dimension and many expressions.

I want to color particular expression column header.

How to do it?

I tried Design Grid and tried to color particular column header, but it is coloring all the column headers.

how we can achieve coloring only few column headers?

Re: Color only particular column header in a straight table

Wed, 02 Jan 2013 09:42:29 GMT

go to menu -- > setting -- >user preference --> design --> clik on show design pattern.

then right clik on chart select custom format cell.

see attached file.

Re: Color only particular column header in a straight table

khadeer — Wed, 02 Jan 2013 09:44:20 GMT

Ctrl+G

Go to required cell which u want format, right click on that custom format cell, u can get different options , colors, bold italic ... all these.

Regards,

Khadeer

Re: Color only particular column header in a straight table

neha_shirsath — Wed, 02 Jan 2013 09:46:55 GMT

Hii,

Select the Chart Properties> In Visual Cues tab select the expression & give the Upper & Lower values.

for example: Upper>=0, Text-Green

Lower<=0, Text-Red

Re: Color only particular column header in a straight table

udaya_kumar — Wed, 02 Jan 2013 09:58:06 GMT

Hi all,

I tried Ctrl + G, design grid and color the header,

but it is coloring all the expession headers. I dont want like this.

But i want like

for example..

I have one dimension and 12 expressions in a straight table,

i want to color, first 3 expression header (only header, not data) as grey color and next 3 expression header as white color, and again next 3 expression headers as grey color and next 3 as white.

How can we achieve this?

Re: Color only particular column header in a straight table

khadeer — Wed, 02 Jan 2013 10:07:51 GMT

Then in expression click(+) in that text color in that RGB(255,255,255)

instead of 255 u have to take color code which color u want. hope it will works

regards,

Khadeer

Re: Color only particular column header in a straight table

khadeer — Wed, 02 Jan 2013 10:11:28 GMT

R u used apply change to option in custom format cell, In that u have current expreesion, All expression, All expressions and dimensions. So select correct one.

Regards,

Khadeer

Re: Color only particular column header in a straight table

udaya_kumar — Wed, 02 Jan 2013 10:18:51 GMT

Hi Khadeer,

This will color the text color of data, but i want something like, check the attached image.

In the attached image, the data is hidden by white box in the table.

But i want to color the header like the attached image

Re: Color only particular column header in a straight table

benjamina — Mon, 25 Feb 2013 08:32:31 GMT

Hello Udaya,

i have the same problem! Do you have a solution?

Regards,

Benjamina

Re: Color only particular column header in a straight table

Thu, 16 May 2013 20:55:12 GMT

Sorry, this is not possible:

http://community.qlik.com/message/327027#327027

Re: Color only particular column header in a straight table

shree909 — Thu, 16 May 2013 21:44:06 GMT

Hi If u want to change the particular header for the expression.

First for that expression give name as space .

second take some text box give the header name and place it on the expression header where u want to change

and make that as Transparent..

This way u can can change the header as long as ur header is static...

Thanks

Re: Color only particular column header in a straight table

Gysbert_Wassenaar — Sat, 18 May 2013 09:30:33 GMT

See here and here for what can and can't be done.

Re: Color only particular column header in a straight table

Sat, 29 Aug 2015 11:40:13 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