Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Valid email address count

Dear,

I need to count valid email address from given below list:

email_address
michael.marchetti@comnos.com
tim.steinlein@comnos.com
michael.marchetti@comnos.de
tim.steinlein@comnos.de
michael.marchetti@unvalid@comnos.de
zain.com
null
zain@hotmail.com

Count result is 5 and also show records in chart object.

Regards,

Zain.

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Another quick-and-dirty (e.g. no check for valid domain extensions):

=sum(if(SubStringCount(email_address,'@')=1,

if(SubStringCount(subfield(email_address,'@',-1),'.') >0,1,0)))

If you want it really correct then first read this. That's what you'll have to implement. If you want to do that kind of validation I recommend you buy a data cleansing tool that's specifically designed for that purpose.


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Another quick-and-dirty (e.g. no check for valid domain extensions):

=sum(if(SubStringCount(email_address,'@')=1,

if(SubStringCount(subfield(email_address,'@',-1),'.') >0,1,0)))

If you want it really correct then first read this. That's what you'll have to implement. If you want to do that kind of validation I recommend you buy a data cleansing tool that's specifically designed for that purpose.


talk is cheap, supply exceeds demand
Not applicable
Author

Thank again for your reply, I am doing  visualizations of data to soft-check data quality, this is user requriment and i am try to fill. They are using Qlikview 11 and want to manage some data quality in it, i know very well  format validation in data is difficult  and some not possible.

Regards,

Zain.