Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
what is the expression or a query to find the number of 'A'characters in the string 'BANGALORE'?
SubStringCount(text, sub_string), e.g. SubStringCount ('abcd', 'ab') returns 1.
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