Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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 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())
Sorry @Anil_Babu_Samineni, you can't color null values with this
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
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
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.
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
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!