topic Re: Background Color for Null Data in Pivot Table in QlikView

Background Color for Null Data in Pivot Table

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

Hi! Is it possible to give background color for null data?

I would like to give condition like: If month> Apr 2015, then LightCyan, else light magenta. this is as far as I can get.

Re: Background Color for Null Data in Pivot Table

Gysbert_Wassenaar — Sun, 15 Jul 2018 11:06:46 GMT

Turn on the Design Grid in the View menu. Then right click on of the cells and choose the option Custom Format Cell. Then click on the Background Color button and change the background color.

Re: Background Color for Null Data in Pivot Table

Anonymous — Sun, 15 Jul 2018 11:57:56 GMT

hi thanks! but I want to give a condition like:

If month>= Apr 2015, then LightCyan, else light magenta.

I tried to use this expression in calculated box:

if(MonthYear>'Mar-2015',LightCyan(),magenta())

It only give me magenta color.

What am i doing wrong?

Re: Background Color for Null Data in Pivot Table

vishsaggi — Sun, 15 Jul 2018 16:53:58 GMT

Can you uncheck Supress 0 values in presentation tab of your chart properties and see if that helps. Are you looking something like below:

Re: Background Color for Null Data in Pivot Table

Anonymous — Sun, 15 Jul 2018 17:46:08 GMT

No. I need all values before may 2015 to be Magenta, and after apr 2015 to be lightcyan.

But I cannot get the correct formula for it