Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ronaldwang
Creator III
Creator III

Qliksense normal table background colour when null value

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

1 Solution

Accepted Solutions
lblumenfeld
Partner Ambassador
Partner Ambassador

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.

View solution in original post

1 Reply
lblumenfeld
Partner Ambassador
Partner Ambassador

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.