https://community.qlik.com/t5/App-Development/Merge-of-Blank-Empty-values/m-p/1948645#M78186 <P>Hello Qlik Geeks,&nbsp;</P> <P>I want to merge blank/empty values of a field <STRONG>RI</STRONG> to 'N' . I am using the below script to do that and it is not working. May I know what am i missing here ? Thank you in Advance</P> <P>&nbsp;</P> <P>If(Isnull(RI), 'N', RI) as RI</P> <P>&nbsp;</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="CVR_1-1656341761035.png" style="width: 207px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/82756iC00CA9494D8DB2C3/image-dimensions/207x158?v=v2" width="207" height="158" role="button" title="CVR_1-1656341761035.png" alt="CVR_1-1656341761035.png" /></span></P> <P>Thank you,</P> <P>CVR</P> <P>&nbsp;</P> Mon, 27 Jun 2022 15:10:53 GMT CVR 2022-06-27T15:10:53Z https://community.qlik.com/t5/App-Development/Merge-of-Blank-Empty-values/m-p/1948645#M78186 <P>Hello Qlik Geeks,&nbsp;</P> <P>I want to merge blank/empty values of a field <STRONG>RI</STRONG> to 'N' . I am using the below script to do that and it is not working. May I know what am i missing here ? Thank you in Advance</P> <P>&nbsp;</P> <P>If(Isnull(RI), 'N', RI) as RI</P> <P>&nbsp;</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="CVR_1-1656341761035.png" style="width: 207px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/82756iC00CA9494D8DB2C3/image-dimensions/207x158?v=v2" width="207" height="158" role="button" title="CVR_1-1656341761035.png" alt="CVR_1-1656341761035.png" /></span></P> <P>Thank you,</P> <P>CVR</P> <P>&nbsp;</P> Mon, 27 Jun 2022 15:10:53 GMT https://community.qlik.com/t5/App-Development/Merge-of-Blank-Empty-values/m-p/1948645#M78186 CVR 2022-06-27T15:10:53Z https://community.qlik.com/t5/App-Development/Merge-of-Blank-Empty-values/m-p/1948651#M78187 <P>A blank is not a null...</P> <P>Try using Len(RI)=0 or, if there's a whitespace, Len(Trim(RI))=0</P> Mon, 27 Jun 2022 15:14:03 GMT https://community.qlik.com/t5/App-Development/Merge-of-Blank-Empty-values/m-p/1948651#M78187 Or 2022-06-27T15:14:03Z