Adding a background color expression to a pivot table

[Jaden]

I have a pivot table that has hours worked by employees per week. We want to highlight, in red, any hours that are zero or null (-).  I know there is a background color expression box and this is the expression I have in there now:

This is just highlighting all zeros in red, as expected:

How do I get this to also highlight nulls (-) as well? Is it something in the expression or something else I'm missing? 

[Anil_Babu_Samineni]

@Jaden Maye they are not really nulls, If you have Only 0?

Instead, try with, Note, there are many ways. 

If([Total Hours]=0 or IsNull([Total Hours]), Red())

[jochem_zw]

Sorry @Anil_Babu_Samineni, you can't color null values with this

[jochem_zw]

if you are on qlik cloud there is new pivot table in the viz bundle, and with this table there is a styling option to color null value cell background

[vinieme12]

the other option is to add dummy data with 0 hr for each date & dimension combination

or if you are on QLikcloud see the suggestion from @jochem_zw 

[Jaden]

Unfortunately I am on Qlik Sense Enterprise, not Qlik Cloud. I did think about adding a dummy record but before I did that I wanted to make sure there wasn't an easier way because there are quite a few missing records where employees forgot to enter their time.

[jochem_zw · Accepted solution]

Ok, than you have to wait for the February 2024 release, probable the new pivot will also be available in this release just like the new Layout Container

[Jaden]

Okay that is good to know. We plan on upgrading to the February 2024 release later this year, so I will refer back to this post once we have upgraded. Thank you all for your help!