Adding Values for Null and Empty values

[nickmarlborough]

Hi, 

I have a column which has:

1) true values - i.e. regular text populating the field

2) null values

3) empty values

I would like in the expression to have it so null values show as 'N/A' and empty values are 'Empty' 

how can i do this in the expression in the table for that column?

[BrunPierre]

?

=If(IsNull([YourField]), 'N/A', If(Len(Trim([YourField])) = 0, 'Empty', [YourField]))

[Anil_Babu_Samineni]

I advise to go with, NullAsValue | Qlik Sense on Windows Help

[neerajthakur]

if(isnull(FieldName)=-1,'N/A',

if(len(FieldName)<=0,'Empty',FieldName)) as FieldName

Try this

[Padma123]

If(IsNull(sales),'N/A',if(sales<>Trim(sales),'Empty',sales))