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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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.

Labels (1)
2 Replies
Miguel_Angel_Baeyens
Support
Support

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