Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Need help in calculating count of valid data in particular column

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

1 Reply
Highlighted
Champion III
Champion III

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))