Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
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
Highlighted

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

View solution in original post

4 Replies
Highlighted

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

View solution in original post

Highlighted
Contributor III
Contributor III

Thanks!, it works perfectly
Highlighted

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.

 

Highlighted
Contributor
Contributor

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