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