topic Re: Emails Domains in QlikView https://community.qlik.com/t5/QlikView/Emails-Domains/m-p/1048807#M933507 <HTML><HEAD></HEAD><BODY><P>Thank you this helped me a lot.</P></BODY></HTML> Wed, 02 Mar 2016 17:54:59 GMT pablomind 2016-03-02T17:54:59Z Emails Domains https://community.qlik.com/t5/QlikView/Emails-Domains/m-p/1048805#M933505 <HTML><HEAD></HEAD><BODY><P>Hi Im trying to write an expression where I ensure there are no blank fields. All with correct corporate address or "NO MAIL".</P><P>I have a table with corporate address (@domain1.com, @domain2.com, etc) with one column called [email_domains.Allow_domains]</P><P></P><P>So far I have this:</P><P>=SUM(IF(Len(Email)&lt;1 ,1,0) ) to ensure there are no blank fields. </P><P>How can I look the domains and count the wrong ones?? In script would be with WHERE but in expression dont work that statement.</P><P>Any help?</P><P></P><P>Thank you for your time,</P><P></P><P>Pablo</P></BODY></HTML> Mon, 29 Feb 2016 11:10:44 GMT https://community.qlik.com/t5/QlikView/Emails-Domains/m-p/1048805#M933505 pablomind 2016-02-29T11:10:44Z Re: Emails Domains https://community.qlik.com/t5/QlikView/Emails-Domains/m-p/1048806#M933506 <HTML><HEAD></HEAD><BODY><P>Maybe something like</P><P></P><P>If( Exists( [email_domains.Allow_domains], '@' &amp; Subfield(Email, '@', 2) ),1,0) </P></BODY></HTML> Mon, 29 Feb 2016 21:06:32 GMT https://community.qlik.com/t5/QlikView/Emails-Domains/m-p/1048806#M933506 swuehl 2016-02-29T21:06:32Z Re: Emails Domains https://community.qlik.com/t5/QlikView/Emails-Domains/m-p/1048807#M933507 <HTML><HEAD></HEAD><BODY><P>Thank you this helped me a lot.</P></BODY></HTML> Wed, 02 Mar 2016 17:54:59 GMT https://community.qlik.com/t5/QlikView/Emails-Domains/m-p/1048807#M933507 pablomind 2016-03-02T17:54:59Z