Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Luminary
Luminary

Re: Qliksense normal table background colour when null value

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
Highlighted
Luminary
Luminary

Re: Qliksense normal table background colour when null value

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