topic Re: Copy the field if value is Null in QlikView https://community.qlik.com/t5/QlikView/Copy-the-field-if-value-is-Null/m-p/118234#M750436 <HTML><HEAD></HEAD><BODY><P>If( IsNull(ChildMaterial), Material, <SPAN style="font-size: 13.3333px;">ChildMaterial)&nbsp;&nbsp;&nbsp;&nbsp; as <SPAN style="font-size: 13.3333px;">ChildMaterial</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Marco</SPAN></P></BODY></HTML> Thu, 08 Nov 2018 11:59:15 GMT Marco 2018-11-08T11:59:15Z Copy the field if value is Null https://community.qlik.com/t5/QlikView/Copy-the-field-if-value-is-Null/m-p/118232#M750434 <HTML><HEAD></HEAD><BODY><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/217836_Capture.JPG" style="height: 94px; width: 620px;" /></P><P>how to write script if the childmaterial field is null, copy the material value to the child material value. </P><P></P><P>but if child material value field have items, then no need to do anythings. </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Copy-the-field-if-value-is-Null/m-p/118232#M750434 prabunakil 2020-11-25T16:16:04Z Re: Copy the field if value is Null https://community.qlik.com/t5/QlikView/Copy-the-field-if-value-is-Null/m-p/118233#M750435 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>If(Len(Trim(ChildMaterial)) = 0, Material, ChildMaterial) as ChildMaterial</STRONG></P></BODY></HTML> Thu, 08 Nov 2018 11:34:48 GMT https://community.qlik.com/t5/QlikView/Copy-the-field-if-value-is-Null/m-p/118233#M750435 sunny_talwar 2018-11-08T11:34:48Z Re: Copy the field if value is Null https://community.qlik.com/t5/QlikView/Copy-the-field-if-value-is-Null/m-p/118234#M750436 <HTML><HEAD></HEAD><BODY><P>If( IsNull(ChildMaterial), Material, <SPAN style="font-size: 13.3333px;">ChildMaterial)&nbsp;&nbsp;&nbsp;&nbsp; as <SPAN style="font-size: 13.3333px;">ChildMaterial</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Marco</SPAN></P></BODY></HTML> Thu, 08 Nov 2018 11:59:15 GMT https://community.qlik.com/t5/QlikView/Copy-the-field-if-value-is-Null/m-p/118234#M750436 Marco 2018-11-08T11:59:15Z