Discussion board where members can get started with QlikView.
Need help in calculating count of valid data, on particular column;
'Cust_name' is column name having below data:
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,
May be this?
LOAD * INLINE [
Using text object:
= Count(IF(NOT WildMatch(Name, '*#*','*@*','*!*') AND NOT ISNUM(Name), Name))