topic Re: Pivot Table visualization - alternating row colors in App Development

Pivot Table visualization - alternating row colors

jerryr125 — Fri, 23 Apr 2021 16:37:30 GMT

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

Re: Pivot Table visualization - alternating row colors

rubenmarin — Sat, 24 Apr 2021 07:20:48 GMT

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))

Re: Pivot Table visualization - alternating row colors

jerryr125 — Tue, 27 Apr 2021 16:23:21 GMT

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

Re: Pivot Table visualization - alternating row colors

dyy — Thu, 27 Feb 2025 21:53:40 GMT

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

Re: Pivot Table visualization - alternating row colors

rubenmarin — Fri, 28 Feb 2025 07:10:41 GMT

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)