Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
mov
Esteemed Contributor III

Re: Count function with Text

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'))