Apply colour to a Null in a straight table

[colinodonnel]

Hello there

How can i change the colour of this null to white

The null is of Type 2 i.e. specific combination of dimensional values is not represented in the data but still has a cell

thanks,

[colinodonnel · Accepted solution]

I think I have found an answer to this in two steps:

1:  Wrap the the formula in alt e.g. alt(formula,0) This ensures that there is always a value.

here is an example Solved: changing dash [-] to zero - Qlik Community - 1156929

2.  Change the formatting to 0.0%; (0.0%);-   change the value to a dash

here is an example Solved: Dash for Zeros, how to get this in QV - Qlik Community - 1130726