topic Re: How to count char in QlikView

How to count char

muniyandi — Tue, 11 Feb 2014 07:26:30 GMT

Hi,

how to count the char, how many times in the field.

Ex: ('abcd,efgh,ijklm,nopqrs,tuvwxyz',',') i want Result 4

('abcd,efgh,ijklm,nopqrs,tuvwxyz','a') i want result 1

Thanks,

Muni

sunilkumarqv — Tue, 11 Feb 2014 07:37:08 GMT

We are not geeting you Please explore what need to ask

Tue, 11 Feb 2014 07:39:26 GMT

try

substringcount( text , substring)

Returns the number of times the string substring appears within the string text. The result is an integer. If there is no match, 0 is returned

Example:

substringcount ( 'abcdefgcdxyz', 'cd' ) returns 2

Sokkorn — Tue, 11 Feb 2014 07:40:37 GMT

Hi Muni,

=SubStringCount('abcd,efgh,ijklm,nopqrs,tuvwxyz',',') -> will return 4

=SubStringCount('abcd,efgh,ijklm,nopqrs,tuvwxyz','a') -> return 1

Regards,

Sokkorn

Tue, 11 Feb 2014 07:43:06 GMT

substringcount( text , substring)

Returns the number of times the string substring appears within the string text. The result is an integer. If there is no match, 0 is returned

Example:

substringcount ( 'abcdefgcdxyz', 'cd' ) returns 2

sunilkumarqv — Tue, 11 Feb 2014 07:43:35 GMT

Sokkorn is correct

Tue, 11 Feb 2014 07:44:57 GMT

Hi Mathew,

Let Inde=IndexLet Inde1=Index('abcd,efgh,ijklm,nopqrs,tuvwxyz','a');

Let Inde1=Index(''abcd,efgh,ijklm,nopqrs,tuvwxyz','a',1);

Let Inde2=Index(''abcd,efgh,ijklm,nopqrs,tuvwxyz','a',2);

Hope this will help you

Regards,

muniyandi — Tue, 11 Feb 2014 07:45:38 GMT

Hi All,

Sokkorn answer is correct

Thanks to all.

Muni