Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Not applicable

Pivot Table Expression header conditional color issue

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.

Colorsnap.png

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

6 Replies
Highlighted

Re: Pivot Table Expression header conditional color issue

Here my example, take a look in visual cues

Highlighted
Not applicable

Re: Pivot Table Expression header conditional color issue

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

Highlighted
Not applicable

Re: Pivot Table Expression header conditional color issue

Image.pngHi,

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

Thanks

Highlighted
Not applicable

Re: Pivot Table Expression header conditional color issue

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

Highlighted
New Contributor III

Re: Pivot Table Expression header conditional color issue

Hi bhavi2803

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

thanks in advance

Benoît

Highlighted
Contributor

Re: Pivot Table Expression header conditional color issue

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