Expression Background Color

[#1]

Formatting Guru's - I've read every post I could find but no solutions to this one yet. I believe it is the same problem as this post:

http://community.qlik.com/forums/t/22346.aspx

Basisically I'm finding it impossible to format the color of an expression label to NOT inherit the formatting of the expression itself. See below, I want the expression labels CY2010 Q3 ..... YoY % NOT to be blue (the expression background color) but plain white. Yes I've tried every chart inter record function I am aware of (rowno(), noofrows(), dimensionality()) AND I have tried using "Custom Format Cell" but it seems these options don't work. The inter chart functions don't work because there is no way to single out the expression label using the functions, the custom format cell option doesn't work because it gets overriden by the expression background color.

Has anybody encountered this, if so have they been able to remedy?

Thanks for anything

[johnw]

I've encountered it. Unfortunately, I don't have a solution.

[#3]

Hi John - Well I'm pretty confident if you don't have a solution that means it's not possible. I appreciate the response as it at least gives me some ammo while working with my users, hopefully they will understand. Maybe an product enhancement in future versions. Thanks again

[johnw · Accepted solution]

Another thread suggested a workaround of putting the totals at the top of the chart and defining the color expression using if(rowno()<>0,rgb(x,y,z)). It seems like that would avoid coloring the total line, and thus avoid coloring the column heading. I changed an example I had like that, with an expression if(rowno() and sum(Sales)>2,yellow()), and it seemed to work. Moving the grand total and not coloring it may not be options for you, of course. In the chart I have with this problem, I do have the grand total on top, but I want it to be conditionally colored like the rest of the chart, so this isn't an option for me. That's probably why I forgot about it.

Thread:

http://community.qlik.com/forums/p/27333/143484.aspx#143484

Customer Portal request that this be fixed:

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

[#5]

John thanks for the follow-up. Yea I believe I read that solution as well but it's not an option for me as I need the TOTALS lines below the expressions, but it's good to know if this wasn't the case. Thanks again. I will go ahead and tag your response as the solution knowing that it's still not perfect due to tool limitations.