Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a list of emailid s, of which some are fake.
How can I count the number of correct ids using set analysis.
What filters I can use in the expressions to draw a chart?
Can you please help me?
Try something like that :
Count({$<email={"*@*.*"}>} email)
What condition the email need to respect for you?
Can you please tell phone number validation expression for set analysis also...
In java there is a generic statement like
JavaScript code to validate an email id
I want to have a similar generic pattern in Qlikview, so that any kind of email can be validated comparing with the above similar pattern.
Hi Kalyani,
In summary, the links provided by Marco say that :
This is a good solution in QlikView, but Macro don't exist in Qlik Sense.
if you want to use your test in QlikView and in Qlik Sense, you must break down your regular expression in several small test, like :
The best way is to use these small tests in the LOAD script to create a Flag :
if( test_1 and test_2 and test_3 and ... and test_n , 1, 0) as _IsEmailValid
And use this expression in the front end : Sum(_IsEmailValid)
If you want to use it directly in set analysis without modify your load script, you need to write it like that :
Count({$<email={"= test_1 and test_2 and test_3 and ... and test_n "}>} email)
That is a regular expression test. Regular expressions don't exist native in Qlik, you can't use Regular Expressions in set analysis.
As has been pointed out earlier, if using QlikVew, you can use regular expression tests in the load script by using module functions. For an example, see:
Qlikview Cookbook: Regular Expression Pattern Matching http://qlikviewcookbook.com/recipes/download-info/regular-expression-pattern-matching/
-Rob