Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Qlikview Pivot table Alternating row colors

We currently have a pivot table with 3 dimensions that has alternating colors on rows. the issue is that when using a formula in the "Background Color" section of each dimension and expression causes the pivot table to show rows that have zeros for the value even when "Suppress Zero-Values" is checked. 

Does anyone know how to show a pivot table with alternating color rows that still hides rows with Nulls AND zeros?

2 Replies
Highlighted
Specialist II
Specialist II

Re: Qlikview Pivot table Alternating row colors

What is your formula in Background color, I suppose, you're using even() function.

Highlighted
Creator
Creator

Re: Qlikview Pivot table Alternating row colors

Yes, we are using "even()". I have also tried "

if(SubStringCount(RowNo()/2,'.')=0 AND RowNo() <> 0,lightgray(),white())