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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
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