Background color in Pivot Tables Functionality Lost?

patrickanderson — Fri, 06 Jul 2012 15:39:01 GMT

As I have upgraded from version 10 to 11 I have noticed a lot of issues and bugs, but one small one that is driving me nuts is, I can not color Dimensions in a Pivot Table.

If I open in version 10 I get:

If I open in Version 11 I get:

Does anyone know if this is a known issue? Is there a workaround?

My dimension color backgroud formula looks like: =if(Dims='LatestEstimate',rgb(254,251,122),if(Dims='Target', White(),if(Dims='Variance', White())))

Any advice would be helpful.

Re: Background color in Pivot Tables Functionality Lost?

Oleg_Troyansky — Sun, 08 Jul 2012 13:47:53 GMT

Patrick,

It looks like a bug. Can you please report it to QlikTech support, with your specific example?

As a work-around, since your Dimension seems to have a fixed number of values, you can make the background fully transparent and overlay the Pivot Table on top of three colored Text Objects.

In order to make the cells transparent, you need to define a transparent color (or no color) for the Background (defined on the Style tab), and also set "Cell Background Color Transparency" to 100% (also on the Style tab). You may have to delete all Dimension Background attribute to make it all work.

Cheers,

Oleg

topic Re: Background color in Pivot Tables Functionality Lost? in QlikView

Background color in Pivot Tables Functionality Lost?

Re: Background color in Pivot Tables Functionality Lost?