Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Conditional format in pivot table

Hi,

I have pivot table if category is empty i want to display the entire column into red color. I wrote expression in background color but it repeats the colors in all empty cells.

QLIK.png

Here category is empty and highlighted rows only red color will appear. Could you please help to achieve this.

Regards,

Yuvaraj G

2 Replies
leonardo_alexsa
Contributor II
Contributor II

Good afternoon.

Try to do this:

=If(Sum(SALES) = 0, RGB(237,28,36))

Change SALES to your Metric.

Digvijay_Singh

May be this -

Capture.PNG