topic Background color in QlikView

Background color

Wed, 05 Aug 2009 15:09:40 GMT

Hello,

I have a column in a table that I give green or red background depending on a value, it looks like this:


if(((avg(trim(Nivå))=32 or avg(left(Nivå,2))=30) and [Förändring %]>0) or (avg(trim(Nivå))<>32 and avg(left(Nivå,2))<>30 and [Förändring %]<0),rgb(210,112,89),
 if((avg(trim(Nivå))<>32 and avg(left(Nivå,2))<>30 and [Förändring %]>0) or ((avg(trim(Nivå))=32 or avg(left(Nivå,2))=30) and [Förändring %]<0),rgb(88,178,13)))

But with this script I also get the header of the column in this color, I want to keep that one white, how do I do that?

Background color

Wed, 11 Nov 2009 18:28:10 GMT

Are you using QV 8.5 or 9?

Because if I set background color to "RGB(x,x,x)", all rows except header are painted in this color. I am using 8.5v.

Background color

prieper — Sun, 15 Nov 2009 02:08:02 GMT

You may include RowNo() = 0 in your condition and assign another colour to the header-row

HTH
Peter

Background color

Wed, 21 Apr 2010 10:18:12 GMT

Hi Per,

I have the same problem, did you find a solution to this yet?

Thanks, Lukas

Background color

michael_anthony — Wed, 21 Apr 2010 12:01:30 GMT

Problem only appears on Pivot Tables, straight tables are okay. I've tried various methods such as RowNo, Dimensionality functions without success. Also tried Custom Formatting cells, again without luck.

I tried to use a macro, but couldn't get to work, although may be possible.

Searches I've previously done on forums all say same problem - appears that QV just does it that way and not much can be done.

Background color

Wed, 21 Apr 2010 12:50:03 GMT

Ok, so it's just another of these little weird things in QV. Thanks for your response.