topic Alternate Background color in Pivot table in QlikView

Alternate Background color in Pivot table

ipauldur — Fri, 17 Feb 2012 01:53:20 GMT

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.

Re: Alternate Background color in Pivot table

jagan — Fri, 17 Feb 2012 04:47:04 GMT

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.

Alternate Background color in Pivot table

ipauldur — Fri, 17 Feb 2012 05:09:25 GMT

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.

Re: Alternate Background color in Pivot table

peschu123 — Wed, 14 Aug 2013 14:03:30 GMT

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