Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Kohli
Contributor

What is the expression or a query to find the number of 'A'characters in the string 'NA

what is the expression or a query to find the number of 'A'characters in the string 'BANGALORE'?

2 Replies
Ivan_Bozov
Valued Contributor

Re: What is the expression or a query to find the number of 'A'characters in the string 'NA

SubStringCount(text, sub_string), e.g. SubStringCount ('abcd', 'ab') returns 1.

Re: What is the expression or a query to find the number of 'A'characters in the string 'NA

Qlik is Case-Sensitive.

=SubStringCount('BANGALORE',Upper('a'))

Or

=SubStringCount('BANGALORE','A')

Or

=SubStringCount('BANGALORE','a') -- This will return Zero because the string is not there in the word

Community Browser