topic Re: How to color column header in this format in QlikView

How to color column header in this format

Tue, 29 Sep 2015 11:27:27 GMT

Re: How to color column header in this format

Anonymous — Tue, 29 Sep 2015 11:38:48 GMT

Hi Shweta,

You can try this, right click on the column you want coloured than in the drop down, choose the custom format cell option. than you can change the column header colour there.

Re: How to color column header in this format

Tue, 29 Sep 2015 11:56:37 GMT

i have tried this, it will not work for single column it change the color all the expression. See the attachment

Re: How to color column header in this format

MK_QSL — Tue, 29 Sep 2015 11:59:44 GMT

You can change individual color of header in Pivot Table only... using Visual Cues !!

Re: How to color column header in this format

nagarjuna_kotha — Tue, 29 Sep 2015 12:11:50 GMT

PFA

Re: How to color column header in this format

avinashelite — Tue, 29 Sep 2015 12:19:24 GMT

shweta08‌

as Manish said we can have this header format only in Pivot table ...

Re: How to color column header in this format

Anonymous — Thu, 12 Nov 2015 07:13:14 GMT

shweta08‌

how you achieved this . I don't think we can change color of individual Header using Visual Cues.

If you have done anything else could you please share.

Thanks

BKC

Re: How to color column header in this format

nagarjuna_kotha — Fri, 13 Nov 2015 05:27:57 GMT

Hi Balkumar,

PFA...

Re: How to color column header in this format

tamilarasu — Fri, 13 Nov 2015 06:28:05 GMT

Nagarjuna,

Working in Pivot table but not in straight table.

Re: How to color column header in this format

Anonymous — Tue, 17 Nov 2015 04:37:34 GMT

Could you please mention steps/screenshots . Actually right now I don't have licensed version of QV with me.

Thanks

BKC

Re: How to color column header in this format

nagarjuna_kotha — Tue, 17 Nov 2015 05:26:51 GMT

Hi Balkumar,

Steps:

1.Open your Pivot Table Go to Properties>>Visual Cues>>In the Background >>Last Box of Colour , change as per your colour. before applying colour select your Column left hand side.

2.Apply it.

Regards,

Nagarjuna

Re: How to color column header in this format

nagarjuna_kotha — Tue, 17 Nov 2015 05:34:32 GMT

Re: How to color column header in this format

Tue, 17 Nov 2015 07:34:36 GMT

Helpful

Re: How to color column header in this format

Anonymous — Mon, 23 Nov 2015 09:08:55 GMT

hi Nagarguna,

Thank you very much for your help. when I use it for numeric expression it working fine but when I am trying to put some symbol in expression color is changing for hole column (Header and column values) . It should only change color for Column Header A .

Please advice . Thanks BKC

Re: How to color column header in this format

nagarjuna_kotha — Mon, 23 Nov 2015 09:44:19 GMT

Hi Balkumar,

I didn't understand properly.Can you explain little more and sample output.

Regards,
Nagarjuna

Re: How to color column header in this format

Anonymous — Tue, 24 Nov 2015 08:45:06 GMT

When I am using sum(col1) or any numeric expression I am able to change header color for that particular expression.

But when I am trying to put any symbol like '↓' or '→' or image in expression and changing the color of header

Its not working QlikView is applying this color to Header as well as data cells.

You can see above screenshot fourth column A is having green color for Header as well as cells . Header should be green like other columns(Third and fifth ) and other cells should be white (below Header data part)

Thanks,

BKC

Re: How to color column header in this format

njmaehler — Fri, 06 Apr 2018 09:15:23 GMT

You can get rid of the colour in the expression column where there is either an image or no data with an if statement on the background colour of the expression (using the little plus sign to expand it). If you are using show partial sums on the pivot table then use Dimensionality to not overwrite the colour of the "total" line.

e.g.

if(Dimensionality() > 1 , white(), //this does not change the total line (I only have 2 levels in my pivot table)

if(Dimensionality() = 1 and (Column(7) = 0 or IsNum(Column(7)) = 0), rgb(243,243,243),

white()

)