topic Expression formatting affecting Label (Header of the Expression) Format in QlikView

Expression formatting affecting Label (Header of the Expression) Format

Anonymous — Wed, 15 Feb 2012 13:31:00 GMT

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.

Expression formatting affecting Label (Header of the Expression) Format

swuehl — Wed, 15 Feb 2012 13:49:31 GMT

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

Expression formatting affecting Label (Header of the Expression) Format

flipside — Wed, 15 Feb 2012 14:32:00 GMT

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

Expression formatting affecting Label (Header of the Expression) Format

flipside — Wed, 15 Feb 2012 15:12:08 GMT

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

Expression formatting affecting Label (Header of the Expression) Format

Anonymous — Thu, 16 Feb 2012 05:01:04 GMT

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

Re: Expression formatting affecting Label (Header of the Expression) Format

Anonymous — Thu, 16 Feb 2012 05:26:37 GMT

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

Re: Expression formatting affecting Label (Header of the Expression) Format

dwh1104 — Thu, 18 Apr 2013 15:31:37 GMT

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.