https://community.qlik.com/t5/Connectivity-Data-Prep/Differences-between-if-IsNull-field-and-If-field-Null/m-p/2076674#M12324 <P>I tried in a script doing If([field]=Null()) and it doesn't work, while if(IsNull([field])) does. Could you explain to me why?</P> Fri, 26 May 2023 08:46:06 GMT DavideT 2023-05-26T08:46:06Z https://community.qlik.com/t5/Connectivity-Data-Prep/Differences-between-if-IsNull-field-and-If-field-Null/m-p/2076674#M12324 <P>I tried in a script doing If([field]=Null()) and it doesn't work, while if(IsNull([field])) does. Could you explain to me why?</P> Fri, 26 May 2023 08:46:06 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Differences-between-if-IsNull-field-and-If-field-Null/m-p/2076674#M12324 DavideT 2023-05-26T08:46:06Z https://community.qlik.com/t5/Connectivity-Data-Prep/Differences-between-if-IsNull-field-and-If-field-Null/m-p/2076689#M12329 <P>Hi,</P> <P>IsNul() returns a logical answer in True or False (<SPAN>-1 or 0 </SPAN>), whereas the Null() function returns ‘-‘ in place of a null value.</P> Fri, 26 May 2023 09:17:56 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Differences-between-if-IsNull-field-and-If-field-Null/m-p/2076689#M12329 BrunPierre 2023-05-26T09:17:56Z