Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Replace Null values

Want to change on Script Side and not In Expression.

1) Tried changing Setnullasvalue;

2) Tried IF (Isnull(Name), ' NoName', 'Name')

Unable to replace nullvalues with 'NoName'

Any Help Plz.

2 Replies
Miguel_Angel_Baeyens

Hello,

Try instead

If(Len(Trim(Field)) > 0, Field, 'Empty') AS Field, // note that Field is the field name (and no quoted) and 'Empty' is a string


Hope this helps.

suniljain
Master
Master

if(Name = '', Field,'No_Data') as Name