Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
krissy_s
Contributor III
Contributor III

Count fields with 4 or less characters, using set analysis

Hi All

I am trying to count the number of records with a field, called "Wording". I would like to count all the records which have 4 or less characters (regardless of type of character, what the string of characters says etc.) in the Wording field. Can someone please assist?

Many thanks

 

 

 

1 Solution

Accepted Solutions
CELAMBARASAN
Partner - Champion
Partner - Champion

Using Set analysis you can get it

Count({<Wording={"=Len(Wording)<=4"}>}Wording)

or 

Count(If(Len(Wording)<=4, Wording))

View solution in original post

2 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Using Set analysis you can get it

Count({<Wording={"=Len(Wording)<=4"}>}Wording)

or 

Count(If(Len(Wording)<=4, Wording))

krissy_s
Contributor III
Contributor III
Author

Thank you so much!!