topic Re: verifying null in two caolumns in Qlik Learning Discussions https://community.qlik.com/t5/Qlik-Learning-Discussions/verifying-null-in-two-caolumns/m-p/809037#M2665 <HTML><HEAD></HEAD><BODY><P>Hi Mahendra</P><P>You can do something like</P><P></P><P>load</P><P>&nbsp; if(customer=null() and Currency=null(), 'Speciality', customer) AS customer,</P><P>&nbsp; Currency</P><P>FROM ...</P><P></P><P>Agis</P></BODY></HTML> Mon, 02 Feb 2015 19:48:46 GMT Agis-Kalogiannis 2015-02-02T19:48:46Z verifying null in two caolumns https://community.qlik.com/t5/Qlik-Learning-Discussions/verifying-null-in-two-caolumns/m-p/809036#M2664 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have two columns customer,Currency</P><P>customer,currency</P><P>-,-</P><P>-,-</P><P>If customer is null and Currency is null.I want to replace null in customer with some text ex;'Speciality'</P><P></P><P>How can I achieve this?</P><P></P><P>Thanks,</P><P>Mahendra.</P></BODY></HTML> Mon, 02 Feb 2015 19:35:51 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/verifying-null-in-two-caolumns/m-p/809036#M2664 2015-02-02T19:35:51Z Re: verifying null in two caolumns https://community.qlik.com/t5/Qlik-Learning-Discussions/verifying-null-in-two-caolumns/m-p/809037#M2665 <HTML><HEAD></HEAD><BODY><P>Hi Mahendra</P><P>You can do something like</P><P></P><P>load</P><P>&nbsp; if(customer=null() and Currency=null(), 'Speciality', customer) AS customer,</P><P>&nbsp; Currency</P><P>FROM ...</P><P></P><P>Agis</P></BODY></HTML> Mon, 02 Feb 2015 19:48:46 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/verifying-null-in-two-caolumns/m-p/809037#M2665 Agis-Kalogiannis 2015-02-02T19:48:46Z Re: verifying null in two caolumns https://community.qlik.com/t5/Qlik-Learning-Discussions/verifying-null-in-two-caolumns/m-p/809038#M2666 <HTML><HEAD></HEAD><BODY><P>if(IsNull(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">customer</SPAN>) and IsNull(currrency), 'Speciality', customer) as customer</P><P></P><P>or</P><P><SPAN style="font-size: 13.3333330154419px;">if(len(trim(</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">customer</SPAN><SPAN style="font-size: 13.3333330154419px;">))=0 and len(trim(currrency))=0, 'Speciality', customer) as customer</SPAN></P></BODY></HTML> Mon, 02 Feb 2015 19:56:33 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/verifying-null-in-two-caolumns/m-p/809038#M2666 maxgro 2015-02-02T19:56:33Z