Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Pedro_Rodriguez
New Contributor III

Pivot table alternate colour by dimension row value

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:

 Captura.PNG

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!

 

Labels (1)
1 Solution

Accepted Solutions

Re: Pivot table alternate colour by dimension row value

Try this expression for background color

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

When 1 and 3 are selected

image.png

When nothing is selected

image.png

2 Replies

Re: Pivot table alternate colour by dimension row value

Try this expression for background color

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

When 1 and 3 are selected

image.png

When nothing is selected

image.png

Pedro_Rodriguez
New Contributor III

Re: Pivot table alternate colour by dimension row value

Thanks!, it works perfectly