Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
hariprasadqv
Contributor III

How to Apply Background Color for Empty Fields in Pivot Table

Hi All,

How can we Apply Background color for Empty Cells in Pivot Table. cell's may contain Text or Numaric value.


Thanks in Advance

5 Replies

Re: How to Apply Background Color for Empty Fields in Pivot Table

May be using this kind of logic:

If(Len(Trim(YourExpression)) = 0, BackGroundColor, OtherColorWhereThereIsValue)

Partner
Partner

Re: How to Apply Background Color for Empty Fields in Pivot Table

if you want to do like below :

Null.png

then see the attached qvw.

qlikviewnovice
Valued Contributor II

Re: How to Apply Background Color for Empty Fields in Pivot Table

Hi Hari,

Please have a look:

Pivot table background color in cells with no data

Hope it helps!!

kkkumar82
Valued Contributor III

Re: How to Apply Background Color for Empty Fields in Pivot Table

Hi,

Hi for the expression in the expressions tab (properties) click ' + ' and you get a tree , there you select the background

and a condition if(isnull(expression), rgb1(n1,n2,n3),rgb1(n1,n2,n3))

Thanks

Kiran Kumar

kkkumar82
Valued Contributor III

Re: How to Apply Background Color for Empty Fields in Pivot Table

Hi,

Sorry for forgetting the same you can find for Dimensions also.

Thanks

Kiran Kumar