Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
pablomind
Creator
Creator

Emails Domains

Hi Im trying to write an expression where I ensure there are no blank fields. All with correct corporate address or "NO MAIL".

I have a table with corporate address (@domain1.com, @domain2.com, etc) with one column called [email_domains.Allow_domains]

So far I have this:

=SUM(IF(Len(Email)<1 ,1,0) ) to ensure there are no blank fields.

How can I look the domains and count the wrong ones?? In script would be with WHERE but in expression dont work that statement.

Any help?

Thank you for your time,

Pablo

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Maybe something like

If( Exists( [email_domains.Allow_domains], '@' & Subfield(Email, '@', 2) ),1,0)

View solution in original post

2 Replies
swuehl
MVP
MVP

Maybe something like

If( Exists( [email_domains.Allow_domains], '@' & Subfield(Email, '@', 2) ),1,0)

pablomind
Creator
Creator
Author

Thank you this helped me a lot.