topic Re: Qlikview Pivot table Alternating row colors in QlikView

Qlikview Pivot table Alternating row colors

olivetwist — Fri, 22 Feb 2019 15:55:51 GMT

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?

Re: Qlikview Pivot table Alternating row colors

sergio0592 — Wed, 27 Feb 2019 18:29:18 GMT

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

Re: Qlikview Pivot table Alternating row colors

olivetwist — Wed, 27 Feb 2019 18:46:50 GMT

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

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