Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ramya_grandhi
New 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
Contributor III

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

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
Highlighted
ramya_grandhi
New Contributor III

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

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
Contributor III

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

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

-Somasundaram