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: 
Kohli
Creator II
Creator II

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
Luminary
Luminary

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

vizmind.eu
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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)