topic Função: SubStringCount in Brasil https://community.qlik.com/t5/Brasil/Fun%C3%A7%C3%A3o-SubStringCount/m-p/671680#M19253 <HTML><HEAD></HEAD><BODY><P>Boa Tarde.!</P><P></P><P>Alguém poderia me dar uma explicação da função abaixo:&nbsp; <IMG src="https://community.qlik.com/legacyfs/online/emoticons/confused.png" /></P><P></P><P>=SubStringCount(Concat(Campo_Tabela,'|'), 'A')</P><P></P><P>Muito Obrigado.</P><P></P><P>Renato</P></BODY></HTML> Thu, 28 Aug 2014 15:14:48 GMT girino777 2014-08-28T15:14:48Z Função: SubStringCount https://community.qlik.com/t5/Brasil/Fun%C3%A7%C3%A3o-SubStringCount/m-p/671680#M19253 <HTML><HEAD></HEAD><BODY><P>Boa Tarde.!</P><P></P><P>Alguém poderia me dar uma explicação da função abaixo:&nbsp; <IMG src="https://community.qlik.com/legacyfs/online/emoticons/confused.png" /></P><P></P><P>=SubStringCount(Concat(Campo_Tabela,'|'), 'A')</P><P></P><P>Muito Obrigado.</P><P></P><P>Renato</P></BODY></HTML> Thu, 28 Aug 2014 15:14:48 GMT https://community.qlik.com/t5/Brasil/Fun%C3%A7%C3%A3o-SubStringCount/m-p/671680#M19253 girino777 2014-08-28T15:14:48Z Re: Função: SubStringCount https://community.qlik.com/t5/Brasil/Fun%C3%A7%C3%A3o-SubStringCount/m-p/671681#M19254 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=SubStringCount(Concat(Campo_Tabela,'|'), 'A')</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Let me divide in two different function...</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Concat(Campo_Tabela,'|')</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">This will concatenate all/selected values of <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Campo_Tabela</SPAN> and the seperator is |</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=SubStringCount(Concat(Campo_Tabela,'|'), 'A')</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">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)....</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Hope this will clear your doubt..</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P></BODY></HTML> Thu, 28 Aug 2014 16:01:43 GMT https://community.qlik.com/t5/Brasil/Fun%C3%A7%C3%A3o-SubStringCount/m-p/671681#M19254 MK_QSL 2014-08-28T16:01:43Z Re: Função: SubStringCount https://community.qlik.com/t5/Brasil/Fun%C3%A7%C3%A3o-SubStringCount/m-p/671682#M19255 <HTML><HEAD></HEAD><BODY><P>OK.!</P><P></P><P>Muito Obrigado.!!</P><P></P><P>Renato</P></BODY></HTML> Thu, 28 Aug 2014 17:13:43 GMT https://community.qlik.com/t5/Brasil/Fun%C3%A7%C3%A3o-SubStringCount/m-p/671682#M19255 girino777 2014-08-28T17:13:43Z