topic Column title color in pivot table with text color expression property in QlikView

Column title color in pivot table with text color expression property

Tue, 15 Sep 2009 23:11:32 GMT

Hi all!

I have an expression in a pivot table that is formatted using "text color" option on expression properties. Depending on the expression value, we show values in red or blue color. It works perfect but the column title color changes too. We want to have the column title in white and the expression values in red or blue.

"Custom format cell" doesn't work because expression color properties seem to override the format values.

Any idea?

Thanks!

Column title color in pivot table with text color expression property

stephencredmond — Tue, 15 Sep 2009 23:42:03 GMT

Hi,

You could try including an If statement incorporating the Dimensionality() function.

Stephen

Column title color in pivot table with text color expression property

Wed, 16 Sep 2009 00:08:59 GMT

When I took a similar question to QlikTech support last year I was told that it is "working as designed". The title seems to take on the color of the "top" cell in the column. It wasn't a big problem for my project so we just decided to ignore it. Sorry I don't have any useful advice.

Column title color in pivot table with text color expression property

Wed, 16 Sep 2009 00:24:35 GMT

Seems to be Tim is right. It takes the color of the first cell. Now if you are that particular that color should not change, try creating a text field and place it over the cell. Not a good idea if you allow to minimize the chart.

Column title color in pivot table with text color expression property

Sun, 27 Sep 2009 02:33:18 GMT

Thanks!

I'll try with the text field... It seems to be the best option.

AW:Re: Column title color in pivot table with text color expression property

Fri, 08 Oct 2010 11:51:50 GMT

Same here,

color of first line or cell. Seems a problem for us in many terms of use. Don't know how to work around!? Seems like a bug and QV show this like a feature. Nice...

Greetings,

Jonas

AW:Re: Column title color in pivot table with text color expression property

johnw — Sat, 09 Oct 2010 00:30:09 GMT

A fix was requested back in 2009 on the Customer Portal. So far it only has three votes. If you want it changed, vote for it! 🙂

https://emea.salesforce.com/ideas/viewIdea.apexp?id=08720000000GnlS&srPos=0&srKp=087