Pivot Table Expression Label - Background Colour

[#1]

Hi,

I've seen posts about this before, but not found an answer, just wondering if anyone has ever cracked it...

Problem is that when using a pivot table and applying a background colour to the cells of an expression, Qlikview colours the background of the label or header for the expression the same colour as the first row for that expression in the table.

Any suggestions, or do i just have to put up with it

Cheers,

Matt

[boorgura · Accepted solution]

There is no direct solution for that except for adding a Total row on the top and in the background color expression, we have to use the condition - if(rowno() <> 0, <do coloring>)

[matt_crowther]

You can use the 'Custom Format Cell' option.

2 Methods both a little convoluted:

A. 1. Switch on the Design Grid. (Icon on menu bar) 2. Under 'User Preferences' > 'Design' check 'Always Show Design Menu Items'. 3. Finally right click on the cell you wish to format and about half way down you should have a new 'Custom Format Cell' option. Select that and it open a wizard.

B. Now for the really crazy way: 1. Select 'Help' > 'About Qlikview'. 2. Right Click on the Qlikview Eye in the bottom left - this opens the Qlikview 'Easter Egg' / debug settings (Be careful; changing the wrong thing may break your install) 3. From the 'Integers' list change 'CustSelCol' to 1 - this will give you the same 'Custom Format Cell' option but without the need to switch on the Design Grid.

Hope that helps - be careful poking around in the debug settings!

(I'm using v9 SR3 incase anything doesn't work)

[#4]

Thanks.. that works for me.

Matt

[rwunderlich]

matt.crowther wrote:
B. Now for the really crazy way: 1. Select 'Help' > 'About Qlikview'. 2. Right Click on the Qlikview Eye in the bottom left - this opens the Qlikview 'Easter Egg' / debug settings (Be careful; changing the wrong thing may break your install) 3. From the 'Integers' list change 'CustSelCol' to 1 - this will give you the same 'Custom Format Cell' option but without the need to switch on the Design Grid.

You can also enable this option in Settings, User Preferences, Design, "Always Show Design Menu Items".

-Rob