Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
vishakhaw
Contributor
Contributor
‎2018-04-05 04:58 AM

How to change the background color of the pivot table with alternate darkgrey and lightgrey including the null values?

Right now I am using

=If(Mod(RowNo(TOTAL), 2) = 0, rgb(243,243,243),rgb(217,217,216))

But the color is not getting applied to the Null() values, the rows having nulls end up with a different stripe.

Any Answers?

398 Views
0 Likes
0 Replies