topic Re: Pivot Table - Dimensions/Expressions background color issue in QlikView

Pivot Table - Dimensions/Expressions background color issue

googel84 — Tue, 18 Mar 2014 12:13:22 GMT

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.

Thanks in advance for any help.

Re: Pivot Table - Dimensions/Expressions background color issue

MK_QSL — Tue, 18 Mar 2014 12:22:26 GMT

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

Re: Pivot Table - Dimensions/Expressions background color issue

googel84 — Tue, 18 Mar 2014 18:29:34 GMT

Fixed!

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

Thanks anyway