topic Pivot Table Expression Label - Background Colour in QlikView

Pivot Table Expression Label - Background Colour

Thu, 21 Oct 2010 17:21:10 GMT

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

Pivot Table Expression Label - Background Colour

boorgura — Thu, 21 Oct 2010 17:26:25 GMT

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>)

Pivot Table Expression Label - Background Colour

matt_crowther — Thu, 21 Oct 2010 17:29:06 GMT

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)

Pivot Table Expression Label - Background Colour

Thu, 21 Oct 2010 22:02:28 GMT

Thanks.. that works for me.

Matt

Pivot Table Expression Label - Background Colour

rwunderlich — Fri, 22 Oct 2010 01:05:37 GMT


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