Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count of fields consisting special character from particular column

Hi All,

I am new to Qlikview,

I need help, I am trying to have count of records from particular column in database, where there is junk data with special  characters.

for e.g.:

 

Name
Robert%#
Ashish
Alax12
Jon

I should get count as 2 , as two fields are there with special characters.

Thank you

1 Solution

Accepted Solutions
tamilarasu

Hi Ashish,

=Count({<Name={"=Len(PurgeChar(Upper(Name),'ABCDEFGHIJKLMNOPQRSTUVWXYZ'))>0"}>}Name)


Or

=Count(If(Len(PurgeChar(Upper(Name),'ABCDEFGHIJKLMNOPQRSTUVWXYZ'))>0,1))

View solution in original post

2 Replies
tamilarasu

Hi Ashish,

=Count({<Name={"=Len(PurgeChar(Upper(Name),'ABCDEFGHIJKLMNOPQRSTUVWXYZ'))>0"}>}Name)


Or

=Count(If(Len(PurgeChar(Upper(Name),'ABCDEFGHIJKLMNOPQRSTUVWXYZ'))>0,1))

View solution in original post

Not applicable

Thanks Nagraj for your reply...

It worked for me .. However could you please help me in below case ...

 

Name
123Art Johnson,III
Dustin Graves
!!!$%VALMONT INDUSTRIES, INC.
PACCAR####
CTC-Suite Renovation Program-1x4
&&&*****Unknown****
****CRM****####
12345 JCI project. 57 Luxor 300 156 Luxor 600
AAP !!!####%%%%&&&

****AAMCOR ***

123134343424542sasdsfpoi*******
Ashish
Yogita
##### Poonam *******####

Sandhya

Madhu******!!!!!!$$$$
Ansuman
***#####&&&***##Anthony****
Soumya
Rohin())()()-----
Amit1234

I would like to have count of field where only number (not char followed by number) , fields with  special char , blank fields and fields with white spaces ?

Could you please help.