topic Re: Background color of Pivot Table Labels in QlikView

Background color of Pivot Table Labels

Wed, 08 Feb 2012 00:24:46 GMT

I have a formula embedded in my Expression "Background" color option of a pivot table. Hence the data cell bg colors change corresponding to the value. Hence the column label bg color changes to the first color displayed in the column.

Can I change/override the bg column label color? I have tried the "View", "Design", "cell format"... but that is not working. Please advise.

Background color of Pivot Table Labels

jagan — Wed, 08 Feb 2012 05:08:08 GMT

Hi,

Are you expecting the to change the Background color of the Column Headers?

Regards,

Jagan.

Background color of Pivot Table Labels

Wed, 08 Feb 2012 05:50:13 GMT

Hi Slind,

If you want to change the back ground of the particular field(Dimension or Expression), select the background colour and apply =rgb( 'xxx','yyy','zzz') where x,y,z represents the value of rgb of the corresponding colour which u want to substitute.

Hope it helps.

Background color of Pivot Table Labels

Wed, 08 Feb 2012 06:29:09 GMT

Hi,

The background colour of the header will always be the like the background colour of the first sorted cell in the same column. As far as I know, this can not be changed. I've faced the same problem in several applications, but did not find a solution.

Regards,

sebablum

Background color of Pivot Table Labels

jagan — Wed, 08 Feb 2012 07:01:02 GMT

Hi,

Can you attach sample file.

Regards,

Jagan.

Re: Background color of Pivot Table Labels

kaushiknsolanki — Wed, 08 Feb 2012 07:08:03 GMT

Hi,

Have a look at the example attched, is this what you want.

Regards,

Kaushik Solanki

Background color of Pivot Table Labels

jagan — Wed, 08 Feb 2012 07:08:40 GMT

Hi,

Instead of setting the background color using BackGround expression, try using the Visual Clues tab in chart properties.

Regards,

Jagan.

Background color of Pivot Table Labels

Wed, 08 Feb 2012 07:22:36 GMT

Yes i agree with Sebablum. the solution which i've given is to change the background colour for the whole column, not only for the label. I don't know whether it's possible to change the colour of label.

Background color of Pivot Table Labels

Sokkorn — Wed, 08 Feb 2012 07:30:20 GMT

Hi Kaushik,

Very useful sample file. Can you help to guide me how to get this done?

Regards,

Sokkorn Cheav

Background color of Pivot Table Labels

kaushiknsolanki — Wed, 08 Feb 2012 07:33:20 GMT

Hi,

All you have to do is first go to Settings-> User preference -> Design -> Check "Always Show design menu item"

Click ok.

Now right click on your chart cell and you will find an option "Custome format cell"

From here you can change the text and background color"

Regards,

Kaushik Solanki

Background color of Pivot Table Labels

Sokkorn — Wed, 08 Feb 2012 07:36:55 GMT

Hi Kaushik,

Awesome and clear guide. Many thanks for your prompt response.

Regards,

Sokkorn Cheav

Re: Background color of Pivot Table Labels

Wed, 08 Feb 2012 10:04:35 GMT

Wow Kaushik,

First of all i would like to say thanks to you for the post. once again u have proved your experience in Qlikview. once again thanks to you for the information which u have provided in the post. really worthful, helpful information.

Warm Regards,

Arun Prasadh.N.

Re: Background color of Pivot Table Labels

Wed, 08 Feb 2012 17:05:32 GMT

Hey folks,

I have updated Kaushik Solanki's attachment by adding a background color pattern to the expression.... NOW try and change the background color of the either of the expression column labels?

I understood and agreed with Sebablum's response (directly below)... but I was hoping we all could still find a solution

"The background colour of the header will always be the like the background colour of the first sorted cell in the same column. As far as I know, this can not be changed. I've faced the same problem in several applications, but did not find a solution.

Regards,

sebablum"

I appreciate all of your feedback, you are a wealth of information.

Stephanie

Re: Background color of Pivot Table Labels

Thu, 09 Feb 2012 12:28:28 GMT

Hi Stephaine,

Thanks for the useful post n worthful attachment.

Regards,

Arun Prasadh.N.

Re: Background color of Pivot Table Labels

Thu, 09 Feb 2012 22:28:48 GMT

was anyone able to figure this out?

Background color of Pivot Table Labels

Anonymous — Wed, 15 Feb 2012 14:15:22 GMT

Wondering the same as slind0503 before me: anyone able to figure this out? I got a beautiful table, but the headers just won't match the columns color...

Background color of Pivot Table Labels

Anonymous — Wed, 15 Feb 2012 14:30:27 GMT

You can change the header color manually in the pivot table

In Pivot table

Properties --> Caption Tab ---> InActive Caption / Active Caption ----> change the background color and Text

color as you want like for your column color

Regards

Ashok

Background color of Pivot Table Labels

Anonymous — Wed, 15 Feb 2012 14:35:49 GMT

Hello Ashok,

sadly, that doesn't work:

As you can see, it only changes the Caption Label, not the Headers (Unique Nr., Customer, BU, etc. etc.)

I want the Header for Gr. Sales Month 1 to be Yellow like the first cell below the Header, and the Header for NSP Month 1 to be Grey like the first cell below the Header.

Thanks for trying to help so fast already .

Kind regards,

Stefan

Re: Background color of Pivot Table Labels

matt_crowther — Wed, 15 Feb 2012 16:12:31 GMT

Attached is a partial solution to this longstanding Qlikview quirk. Basically I'm using Visual Cues to highlight values in the data; this isn't as flexible as controlling the Background Color / Text Color but crucially it doesn't interfere with the Header colour. As we're looking at a Pivot the Visual Cues spread across all columns but in this example the user only wanted the Totals to be highlighted so I'm using a Text Color expression to set the colour to black thus over-riding the Visual Cue and making it look as needed.

If your assignment of colour is complex then this solution won't work as you're contrained by the inflexibility of the Visual Cues process, however; if your data suits then this solution can be useful.

All the best,

Matt - Visual Analytics Ltd

Qlikview Design Blog: http://QVDesign.wordpress.com

Re: Background color of Pivot Table Labels

Wed, 15 Feb 2012 23:01:34 GMT

nope