topic Conditional format in pivot table in QlikView

Conditional format in pivot table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

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

Regards,

Yuvaraj G

Re: Conditional format in pivot table

leonardo_alexsa — Fri, 09 Mar 2018 19:23:04 GMT

Good afternoon.

Try to do this:

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

Change SALES to your Metric.

Re: Conditional format in pivot table

Digvijay_Singh — Fri, 09 Mar 2018 19:47:40 GMT

May be this -