Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count function with Text

I am trying to create a COUNT function that will search out a word in the table [WORKORDER DESCRIPTION].  I am trying to pull out the word 'Ants' and place them in a bar chart. I also don't know if the word will be case sensitive.

1.jpg

1 Reply
Anonymous
Not applicable
Author

If you want to detect string 'ants', not case-sensitive, but no count, use

wildmatch([WORKORDER DESCRIPTION], '*ants*')

It will return 0 if there is no match, and a positive number if there is at least one.

If you really need count, use :

substringcount(upper([WORKORDER DESCRIPTION], 'ANTS'))