Apply background color expression to Null value

[FFBB1983]

Hi,

I am applying RGB(248,203,173) to the last column in my table. However, the color didn't apply to the cell without value.

By far, I have tried the following scripts. Can you please let me know the right way to write?

if(IsNull(Max(TranDate)),rgb(248,203,173),rgb(248,203,173))

if(Max(TranDate)='',rgb(248,203,173), rgb(248,203,173))

if(isnull(Max(TranDate)), rgb(248,203,173))

[Anil_Babu_Samineni]

What is the original expression?

[FFBB1983]

Original expression is Max(TranDate)

I added rgb(248,203,173) to the background color expression. This only put the color for the cells with value and leave the null cell gray. I would like to apply the same color to the null cell and make it looks consistent.

[FFBB1983]

Can anyone help with this question?

[Anil_Babu_Samineni]

Check this?

if(IsNull(Max(TranDate)) or Len(Max(TranDate))=0,rgb(248,203,173))

[FFBB1983]

Still not working.

It gives me this,

[naveen_qlik]

any update on this?

[Ken_T]

https://community.qlik.com/t5/New-to-Qlik-Sense/Qliksense-normal-table-background-colour-when-null-v...    this thread implies that the background color expression wont work unless there is a value in the cell.   It would be good if qlik support or a qlik employee could confirm this...