Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))
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))
Thank you - yes, I see the indented rows can have an effect on this - appreciate your help! Jerry