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

[Kohli]

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

[Ivan_Bozov]

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

[Anil_Babu_Samineni]

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