Replace NULL value in condition

[BearNBeer]

Hello,

I'm very new in Qliksense and I wrote a very simple condition that checks if a field is equal to 0 :

=if( field = 0, 'field = 0', 'field not = 0')

My result looks like that :

 

As you can see I have 1226 NULL values represented by a '-' .

What I would like to know is how I could put these NULL values in the 'field not = 0' line ?

Thank you in advance.

[Taoufiq_Zarra]

Maye be :

=if( lent(trim(field))= 0 or field=0 , 'field = 0', 'field not = 0')

[Vegar]

It could be that you dont have data assoiciated to any field. 

Consider the example above/attached. 

I have a transaction for ID 6, but no definition in the Fields dimension table. Notice that the NULL() value is defined as "Field not = 0".