Expression formatting affecting Label (Header of the Expression) Format

[Anonymous]

Hi,

I am facing a problem while setting the format of any expression in a Pivot table. For example below I have Sells figures for each month. Now in a pivot table I am showing the total Sell for each month. So in the Dimentions I used Month and in the expression I used Sum(Sell).

Now I want to format the Expression(Total Sell) as per condition. Here I am using if the total sell is more than 30 it will be Green else Red. Though its working, but problem is The Label (Header of the Expression) is also getting formatted, which I dont want.

Expression:

Formatting:

Its not only the background color, its happening in case of text format, Text color also. Can anyone help how to avoid this or where I am going wrong.

I am using QV 9 SR 6.

[swuehl]

Though most people will call this a bug and it has been reported to QV long time ago, it seems to still be present in QV11. I also have no real solution to this, maybe some of these discussions are helpful to you:

http://community.qlik.com/message/140105

http://community.qlik.com/message/61757

[flipside]

Hi,

Could you use Visual Cues for your situation?  This doesn't affect the label, but you might need to force the formatting on total columns using something like ...

=if(Sell=sum(Sell),RGB(0,0,0))

This gives three colours Upper, Normal and Lower.  Perhaps using variables in a conditional colour expression, more could be achieved.

flipside

[flipside]

Had 5 minutes to play around and came up with an alternative colour/weight indicator using a traffic light gauge in an additional column. This one is showing share of sales.

flipside

[Anonymous]

Thank you all.. but sadly non of the above is helpful... I am still facing the problem. Any other solution to this ?

[Anonymous · Accepted solution]

Hi Bharat,

          Hope the attached file will be helpful for your problem.

          You can change the color in Pivot chart  based on your sell condition >30

Set,

          Properties ---> Visual cues ----> Upper >= 30 and select your green color

                                                           Lower <= 30 and select your Red color

Refer this attached file

Regards

Ashok

[dwh1104]

I have just upgraded to QV11.2 SR1 and the column label no longer takes the value of the expression background color or text format.  I did not see anything in the release notes that this "bug" was fixed.  Unfortunately, now that we have adapted to the way it was working in QV10, now we need a way to change the labels to match the expression formatting.