
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
