Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Partner
Partner

Pivot Table - Dimensions/Expressions background color issue

Hi there, I am currently facing a strange issue with my pivot table. The problem is that, when I try to color dimensions or expressions background by means of the following expression:

=if(mod(rowno(),2) = 0, rgb(216,216,216))

As a result, one empty row seems to be added to the table and I can't figure out the reason why this is happening.

I tried also to avoid row # 0 with this:

=if(rowno() <> 0,if(mod(rowno(),2) = 0, rgb(216,216,216)))

but the result is always the same, as shown in the picture below.

Immagine1.png

Thanks in advance for any help.

1 Solution

Accepted Solutions
Partner
Partner

Re: Pivot Table - Dimensions/Expressions background color issue

Fixed!

There was an issue with the underlying data; once I have fixed that, the above formulas work perfercly.

Thanks anyway

View solution in original post

2 Replies
MVP
MVP

Re: Pivot Table - Dimensions/Expressions background color issue

The below should work.. It's working fine in my apps.

I not working in your apps, please upload your sample apps with reduced data... or dummy apps.

=IF(MOD(RowNo(),2)=0,RGB(216,216,216))

Partner
Partner

Re: Pivot Table - Dimensions/Expressions background color issue

Fixed!

There was an issue with the underlying data; once I have fixed that, the above formulas work perfercly.

Thanks anyway

View solution in original post