Alternate Background color in Pivot table

[ipauldur]

Hi,

I want to shade the repeating color in pivot dimensions. It is like, all odd rows will be one color and the even rows should be in another color.

I attached the sample Qv file. In that file, i want to put the color based on Unit dimension in to all dimensions.

I tried with the Aggr() & Rank() functions. But didn't worked.

Basically the color should be based on the second column "Test" values. The expression is working fine. but the color is not showing perfectly.

Please suggest.

Thanks in advance,

Durai.

[jagan]

Hi,

Use this expression as Background color expression for all Expressions and Dimensions.

=If(Even(RowNo(TOTAL)), RGB(255, 255, 255), RGB(100,100,100))

Check the attachment.

Hope this helps you.

Regards,

Jagan.

[ipauldur]

Hi Jagan,

Thanks for the reply.

Still its not working. I don't want to put color based on last dimension.

Look at my Qlikview file, I am putting the Year & Month dimensions on top of the expression.

I want the color based on "Unit" column. Means, After that "Unit" column the row may be splitted based on tenant column. But still i want the same color for those tenant which is belong to the same "Unit".

Can you check with my file?

Thanks,

Durai.

[peschu123]

Hi jagan,

I tried your solution, but unfortunatly it has a negative impact on the sorting function of my straight table. When added as expression for background color, I'm not able to sort my expressions anymore. I just can sort via the dimension Headers.

Regards,

Peter