topic Re: Pivot Table Expression header conditional color issue in QlikView

Pivot Table Expression header conditional color issue

Wed, 11 Feb 2015 11:26:28 GMT

Hi Friends,

I have a pivot table where I have to give different background color to different year set data.everything is going correct but I am not able to color the header of the expression.if anyone has any idea or any suggestion please share with me.

I want to color sales and cost header same as their value have.please find a sample app in attachment

Re: Pivot Table Expression header conditional color issue

alexandros17 — Wed, 11 Feb 2015 11:33:16 GMT

Here my example, take a look in visual cues

Re: Pivot Table Expression header conditional color issue

Wed, 11 Feb 2015 11:38:12 GMT

hi Alessandro ,

Thank you for reply but I need conditional color means for 2012 sales and cost header in purple and for year 2013 Sales and Cost Header must be in Sky blue and for grand total it must be in Gray

Re: Pivot Table Expression header conditional color issue

Wed, 11 Feb 2015 11:54:36 GMT

Hi,

You can use Custom Format Cell to change the colour of dimension header.

Thanks

Re: Pivot Table Expression header conditional color issue

Wed, 11 Feb 2015 13:26:20 GMT

I know the option or custom cell option but see for year 2012 and 2013 the header color for expression is same i.e. pink but I need different for each year

Re: Pivot Table Expression header conditional color issue

girard_ben — Mon, 04 Jul 2016 14:19:28 GMT

Hi bhavi2803

did you resolve your issue ? I have exactly the same case !!

thanks in advance

Benoît

Re: Pivot Table Expression header conditional color issue

Anonymous — Tue, 20 Feb 2018 15:49:24 GMT

Hello,

I have currently the same issue with expression headers.

Is there maybe meanwhile a suitable solution for that?

I know the option for "Custom Format Cell" or the properties "Visualization". Both are not solving the question with individual header background colors for the above dimension.

I tried also to calculate the background color within a value list below the expressions and below the Tab "Visualization". Unfortunately this hasn't worked...

Many thanks for every hint and best regards,

Claus