topic Re: Flag both null and certain values in QlikView https://community.qlik.com/t5/QlikView/Flag-both-null-and-certain-values/m-p/1377640#M614016 <HTML><HEAD></HEAD><BODY><P>Thank you for your help!</P></BODY></HTML> Mon, 02 Oct 2017 10:43:44 GMT Anonymous 2017-10-02T10:43:44Z Flag both null and certain values https://community.qlik.com/t5/QlikView/Flag-both-null-and-certain-values/m-p/1377638#M614014 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have customers with addresses: some of them have a countrycode, while some of them have "null" countrycode. I want to find, (with an&nbsp; action-button, Select in Field) the customers, that have vaules 6 or 7 or null. Should I flag them in the script? How can I flag both null-values and certain values?</P></BODY></HTML> Mon, 02 Oct 2017 08:39:26 GMT https://community.qlik.com/t5/QlikView/Flag-both-null-and-certain-values/m-p/1377638#M614014 Anonymous 2017-10-02T08:39:26Z Re: Flag both null and certain values https://community.qlik.com/t5/QlikView/Flag-both-null-and-certain-values/m-p/1377639#M614015 <HTML><HEAD></HEAD><BODY><P>A flag in the script could look like</P><P></P><P>CountryTable:</P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Country,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; CountryCode,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; If(len(trim(CountryCode))=0 or match(CountryCode ,6,7),1,0) as CountryCodeFlag,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; ...</P><P>FROM ...;</P></BODY></HTML> Mon, 02 Oct 2017 08:46:09 GMT https://community.qlik.com/t5/QlikView/Flag-both-null-and-certain-values/m-p/1377639#M614015 swuehl 2017-10-02T08:46:09Z Re: Flag both null and certain values https://community.qlik.com/t5/QlikView/Flag-both-null-and-certain-values/m-p/1377640#M614016 <HTML><HEAD></HEAD><BODY><P>Thank you for your help!</P></BODY></HTML> Mon, 02 Oct 2017 10:43:44 GMT https://community.qlik.com/t5/QlikView/Flag-both-null-and-certain-values/m-p/1377640#M614016 Anonymous 2017-10-02T10:43:44Z