Background color in Pivot Tables Functionality Lost?

[patrickanderson]

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.

[Oleg_Troyansky]

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