topic color each row different, header is also colored in QlikView

color each row different, header is also colored

amien — Fri, 06 Apr 2012 18:24:17 GMT

i use this to color my colors in the background expression:

=IF(MOD(ROWNO(TOTAL),2)=0,RGB(204,204,255),IF(MOD(ROWNO(TOTAL),2)=1,WHITE(),BLACK()))

works perfectly, except that the header is also colored, and not changed to black. Customer Format field doesn't help.

How can i fix this?

Jason_Michaelides — Fri, 06 Apr 2012 22:15:24 GMT

Try adding a Dimensionality() clause to the IF statement. Doesn't always work but it might in your case:

=IF(Dimensionality()=0,Black(),IF(MOD(ROWNO(TOTAL),2)=0,RGB(204,204,255),IF(MOD(ROWNO(TOTAL),2)=1,WHITE(),BLACK())))

Hope this helps,

Jason

amien — Sat, 07 Apr 2012 15:08:19 GMT

Nope , doesn't help.

i switched to a straight table instead of a pivot. It sufficient for now, but i would like the solution to this problem for the future.

Jason_Michaelides — Sat, 07 Apr 2012 15:44:47 GMT

Can you post your app?

swuehl — Sat, 07 Apr 2012 18:55:54 GMT

If I understand correctly, you are talking about this issue:

I think this is still present in QV11.

amien — Sat, 07 Apr 2012 19:05:56 GMT

it's still present in QV11 .. but there are bigger issues in QV11 than this

i dont see how i can use your link. It describes to use the visual cues.

But i need to color the row based on the rowno not on an expression.

if rowno is even then color1, else color2

i could make an expression for this and then put the visual cue on it. But it will give me an addiontal column, which i dont want.