Merge of Blank/Empty values

[CVR]

Hello Qlik Geeks, 

I want to merge blank/empty values of a field RI to 'N' . I am using the below script to do that and it is not working. May I know what am i missing here ? Thank you in Advance

If(Isnull(RI), 'N', RI) as RI

Thank you,

CVR

[Or · Accepted solution]

A blank is not a null...

Try using Len(RI)=0 or, if there's a whitespace, Len(Trim(RI))=0