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: 
girino777
Creator III
Creator III

Função: SubStringCount

Boa Tarde.!

Alguém poderia me dar uma explicação da função abaixo: 

=SubStringCount(Concat(Campo_Tabela,'|'), 'A')

Muito Obrigado.

Renato

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

=SubStringCount(Concat(Campo_Tabela,'|'), 'A')


Let me divide in two different function...

Concat(Campo_Tabela,'|')

This will concatenate all/selected values of Campo_Tabela and the seperator is |


=SubStringCount(Concat(Campo_Tabela,'|'), 'A')

SubstringCount will check that from the above concatenation result will have 'A' inside or not... It is is there, it will give you 1 (=True) or 0 (=False)....


Hope this will clear your doubt..



View solution in original post

2 Replies
MK_QSL
MVP
MVP

=SubStringCount(Concat(Campo_Tabela,'|'), 'A')


Let me divide in two different function...

Concat(Campo_Tabela,'|')

This will concatenate all/selected values of Campo_Tabela and the seperator is |


=SubStringCount(Concat(Campo_Tabela,'|'), 'A')

SubstringCount will check that from the above concatenation result will have 'A' inside or not... It is is there, it will give you 1 (=True) or 0 (=False)....


Hope this will clear your doubt..



girino777
Creator III
Creator III
Author

OK.!

Muito Obrigado.!!

Renato