Qliksense pivot table background colour when null value

[Newbie_QLIK]

Hi Qlik Community,

I hope this message finds you well.

I’ve learned that Qlik Sense doesn’t apply background color to cells with null values because it doesn’t insert anything into those cells. In a previous discussion (link), lblumenfeld suggested placing a space in the cell for null values to ensure the background color is applied (e.g., If(Not IsNull([Your Field]), [Your Field], ' ')).

I tried this approach, but it didn’t work. Can anyone help identify the problem in the following expression?

=if(not isNull(
pick(Dim,
count(Saleproduct),
count(Saleproduct)/(200/5/12),
count(Saleproduct)/(200/12),
rangesum(count(Saleproduct))
)
),
pick(Dim,
count(Saleproduct),
count(Saleproduct)/(200/5/12),
count(Saleproduct)/(200/12),
rangesum(count(Saleproduct))
),
""
)

Thank you for reading!

If you have any alternative methods to achieve this, please feel free to share.

Best,

Newbie_Qlik

[Newbie_QLIK]

Great that Qlik sense 2024 has done something for null values!

I am looking forwards to it. I need to wait my company to update that new version.

Thanks again @MatheusC 

Best,

[datagrrl]

I am confused that you are still getting Null Values when you use the updated expression according to the screen shot you shared.

Maybe it is a version thing, but you should be getting blanks, not nulls.

After that I would take a look at at your color expression. I struggled to get your expression to work correctly with my blank values, but when I stripped it down to if(Dimensionality()=1,red(),blue()) it worked fine for the blanks.

[Newbie_QLIK]

Thank you @datagrrl  for checking!! I will wait for the new version to be installed 🙂