Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ramya_grandhi
Contributor III
Contributor III

How to give background color to Cells that has no value in Pivot Table

Hi All,

I have a pivot table in which some of the values are '0' and some values are nulls (-). My requirement is to give background color to the "empty cells" and also cells with '0' value.

Can anyone help me on this.

 

Labels (2)
3 Replies
Somasundaram
Creator III
Creator III

Hi Ramya,

 

Measure properties, In back ground color expression,

=IF(sum(Field)<=0,RGB(123,123,123)) 

Provide correct RGB color.  Hope it will help.


-Somasundaram

If this resolves your Query please like and accept this as an answer.
ramya_grandhi
Contributor III
Contributor III
Author

Hi Somasundaram,

Thanks for your reply,

My Pivot table is having positive, negative, 0 and null values. If I use Sum(Sales)<=0 it will color the negative values and 0 but not the empty cells.

Somasundaram
Creator III
Creator III

May be this
=IF(isnull(field) or sum(Field)<=0,RGB(123,123,123))

-Somasundaram

If this resolves your Query please like and accept this as an answer.