topic double null flag in App Development https://community.qlik.com/t5/App-Development/double-null-flag/m-p/945098#M13342 <HTML><HEAD></HEAD><BODY><P>Hiya</P><P></P><P>I wish to produce a null flag in the data load</P><P></P><P>this works for 1 column on a record</P><P></P><P>If(len("Depot"),0, 1) AS NullFlag,</P><P></P><P>how do I produce a flag for each record if 2 columns in a row are null?</P><P></P><P>e.g Depot is null and Factory is null</P><P></P><P>Please help</P></BODY></HTML> Fri, 09 Oct 2015 10:03:52 GMT joeybird 2015-10-09T10:03:52Z double null flag https://community.qlik.com/t5/App-Development/double-null-flag/m-p/945098#M13342 <HTML><HEAD></HEAD><BODY><P>Hiya</P><P></P><P>I wish to produce a null flag in the data load</P><P></P><P>this works for 1 column on a record</P><P></P><P>If(len("Depot"),0, 1) AS NullFlag,</P><P></P><P>how do I produce a flag for each record if 2 columns in a row are null?</P><P></P><P>e.g Depot is null and Factory is null</P><P></P><P>Please help</P></BODY></HTML> Fri, 09 Oct 2015 10:03:52 GMT https://community.qlik.com/t5/App-Development/double-null-flag/m-p/945098#M13342 joeybird 2015-10-09T10:03:52Z Re: double null flag https://community.qlik.com/t5/App-Development/double-null-flag/m-p/945099#M13343 <HTML><HEAD></HEAD><BODY><P>if(len(trim(Depot))=0 and len(trim(Factory))=0, 1,0) as DoubleNullFlag</P></BODY></HTML> Fri, 09 Oct 2015 10:16:37 GMT https://community.qlik.com/t5/App-Development/double-null-flag/m-p/945099#M13343 Gysbert_Wassenaar 2015-10-09T10:16:37Z Re: double null flag https://community.qlik.com/t5/App-Development/double-null-flag/m-p/945100#M13344 <HTML><HEAD></HEAD><BODY><P>Hiya</P><P></P><P>fab, all works thanks Gysbert!! </P></BODY></HTML> Fri, 09 Oct 2015 10:35:14 GMT https://community.qlik.com/t5/App-Development/double-null-flag/m-p/945100#M13344 joeybird 2015-10-09T10:35:14Z