Pivot Table visualization - alternating row colors

[jerryr125]

Hi - 

I currently have a Qlik Sense Pivot Table visualization.

I would like to alternate the row colors  so that every other row is blue (as an example).

The issue I have come across is that I am using three rows of data  - three levels of data (example : Organization,  Department, Team)

I tried this :

=if(rowNo()/2=floor(rowNo()/2),RGB(255, 255, 255),RGB(221,236,247))

It does color the rows but inconsistent when you go to the third level .

Thoughts ? thanks - Jerry

[rubenmarin · Accepted solution]

Hi, If you don't have indented rows (checkbox on presentation tab) this may work: =if(Even(RowNo(TOTAL)),RGB(255, 255, 255),RGB(221,236,247))

[jerryr125]

Thank you - yes,  I see the indented rows can have an effect on this - appreciate your help! Jerry

[dyy]

How did you deal with nulls?  this will not  shade any cells with null  values

[rubenmarin]

Hi, I explain that cells without any value between vertical and horizaontal dimensions is not painted, and usually it's accepted.

If it's mandatory to paint all cells, you'll need to create a value for each combination, which might be not viable if there are too many combinations (from dimensions and selectors)