topic Need help in calculating count of valid data in particular column in QlikView

Need help in calculating count of valid data in particular column

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Need help in calculating count of valid data, on particular column;

for e.g.

'Cust_name' is column name having below data:

Antony

paul

Ashish1234

#tony

Jas@n!

423165

Vish@l

I should get count as 3 - as valid data for us is - only char+ char-num (i.e.Antony, paul, Ashish1234 is valid data).

Data where only numbers, special char are present is not valid.

I tried doing same with purgechar/ keepchar but facing problem identifying data like 'Ashish1234' where char+numbers are present.

appreciate your help !

Thanks and Regards,

Ashish

Re: Need help in calculating count of valid data in particular column

vishsaggi — Tue, 13 Jun 2017 16:20:30 GMT

May be this?

LOAD * INLINE [

Name

Antony

paul

Ashish1234

#tony

Jas@n!

423165

Vish@l

];

Using text object:

= Count(IF(NOT WildMatch(Name, '*#*','*@*','*!*') AND NOT ISNUM(Name), Name))