Pivot table alternate colour by dimension row value

[Pedro_Rodriguez]

Hi all,

I have a pivot table, and I want to get alternate colours on it based on the first dimension value. Something like this:

 

The thing is that if I select 1 & 3 in Dim1, I need 1 in white and 3 in yellow.

Find enclosed this case

Thanks a lot in advance!

[sunny_talwar · Accepted solution]

Try this expression for background color

=If(Even(Aggr(NODISTINCT RowNo(), Dim1)), Yellow())

When 1 and 3 are selected

When nothing is selected

[Pedro_Rodriguez]

Thanks!, it works perfectly

[PriyankaShivhare]

Hi,

I am trying to workout the same formula for my qliksense pivot table with latest edition of background colour feature for pivot dimensions. but it is not working. here my dim1 is not numeric .

Thanks in advance.

[FelixM]

I get stuck in the same problem. My Account Dim = HDCT. Coloring the row just by dimension works. But it doesn't work on the 0 / null values for the HDCT row. Means all values > /< in the HDCT row get colored  correct. The zeros don't. I'd like to have the zero's colored too with the same format.

Thanks very much for the help