topic Re: Phone number validation using set analysis in QlikView

Phone number validation using set analysis

Fri, 06 Jan 2017 20:59:51 GMT

Can some one tell me the set analysis expression for phone number validation?

Fri, 06 Jan 2017 21:04:09 GMT

Sample Inline table

Table:

Load * inline

[

ID,Email, PNo.

5,michael.marchetti@unvalid@comnos.de,(732)897-7362

6,zain.com,12345

];

I should get the answer for valid phone numbers as 3 showing in bar chart

Nicole-Smith — Fri, 06 Jan 2017 22:28:01 GMT

I think something like this would work:

count({<[PNo.]={'=WildMatch(KeepChar([PNo.],''0123456789''),''??????????'')'}>}[PNo.])

I've also attached an example file.