Qliksense normal table background colour when null value

[ronaldwang]

in Qliksense normal table when background colour is applied, it is not applicable when null value appears, makes the table looks strange, any setting need be used to adjust for this? thanks

[lblumenfeld · Accepted solution]

That is correct. Qlik Sense doesn't apply the background color when the cell is null. Behind the scenes, that 's because it doesn't put anything into that cell. The only work-around I've found is to put a space in the cell when it's null. Then the background color will get applied.

So... If(not IsNull([Your Field]), [Your Field], ' ')

I hope that helps.

[Newbie_QLIK]

That is a brilliant idea! May I ask you where do you put that code? (in the expression section of Mesures?)

I tried but it did not work in my pivot table. I tried the following expressions: 

           - (If(Count(my field name) = NULL(), 'NA', Count(my field name))

           -  If(not IsNull Count(my field name), Count(my field name), ' ')

One example would appreciate very much!

Thank you so much for your reply.

Best,

Newbie