topic Replace Null values in QlikView https://community.qlik.com/t5/QlikView/Replace-Null-values/m-p/215692#M69105 <HTML><HEAD></HEAD><BODY><P>if(Name = '', Field,'No_Data') as Name</P></BODY></HTML> Mon, 14 Feb 2011 18:07:27 GMT suniljain 2011-02-14T18:07:27Z Replace Null values https://community.qlik.com/t5/QlikView/Replace-Null-values/m-p/215690#M69103 <HTML><HEAD></HEAD><BODY><P>Want to change on Script Side and not In Expression.</P><P>1) Tried changing Setnullasvalue;</P><P>2) Tried IF (Isnull(Name), ' NoName', 'Name')</P><P>Unable to replace nullvalues with 'NoName'</P><P>Any Help Plz.</P></BODY></HTML> Mon, 14 Feb 2011 17:46:11 GMT https://community.qlik.com/t5/QlikView/Replace-Null-values/m-p/215690#M69103 2011-02-14T17:46:11Z Replace Null values https://community.qlik.com/t5/QlikView/Replace-Null-values/m-p/215691#M69104 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>Try instead</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">If(Len(Trim(Field)) &gt; 0, Field, 'Empty') AS Field, // note that Field is the field name (and no quoted) and 'Empty' is a string</PRE></BLOCKQUOTE><BR /><BR /> <P>Hope this helps.</P></BODY></HTML> Mon, 14 Feb 2011 17:51:01 GMT https://community.qlik.com/t5/QlikView/Replace-Null-values/m-p/215691#M69104 Miguel_Angel_Baeyens 2011-02-14T17:51:01Z Replace Null values https://community.qlik.com/t5/QlikView/Replace-Null-values/m-p/215692#M69105 <HTML><HEAD></HEAD><BODY><P>if(Name = '', Field,'No_Data') as Name</P></BODY></HTML> Mon, 14 Feb 2011 18:07:27 GMT https://community.qlik.com/t5/QlikView/Replace-Null-values/m-p/215692#M69105 suniljain 2011-02-14T18:07:27Z