Discussion Board for collaboration on QlikView Layout & Visualizations.
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!
Go to Solution.
Try this expression for background color
=If(Even(Aggr(NODISTINCT RowNo(), Dim1)), Yellow())
When 1 and 3 are selected
When nothing is selected