Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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
Champion
Champion

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

Hi Ashish,

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


Or

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

Not applicable
Author

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.