topic Re: Can any one explan substing count,concatinate functions in QlikView https://community.qlik.com/t5/QlikView/Can-any-one-explan-substing-count-concatinate-functions/m-p/776496#M1021633 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In this expression, the Concat() function will concatenate all the selected or possible Dimension_List_Ord values separating them with a Pipe (for example, Dimension_List_Ord | Dimension_List_Ord | Dimension_List_Ord ).&nbsp; The Substringcount() function will then check that string and will return the number of times that "a" is in that string.&nbsp; </P><P></P><P></P><P>Please refer the attached file.</P></BODY></HTML> Tue, 24 Mar 2015 07:42:02 GMT sagarkharpude 2015-03-24T07:42:02Z Can any one explan substing count,concatinate functions https://community.qlik.com/t5/QlikView/Can-any-one-explan-substing-count-concatinate-functions/m-p/776495#M1021632 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P> Can any one help me SubStringCount(Concat(Dimension_List_Ord,'|'),'a')&nbsp;&nbsp; how it works.</P><P>Thanks,</P></BODY></HTML> Tue, 24 Mar 2015 07:37:23 GMT https://community.qlik.com/t5/QlikView/Can-any-one-explan-substing-count-concatinate-functions/m-p/776495#M1021632 Anonymous 2015-03-24T07:37:23Z Re: Can any one explan substing count,concatinate functions https://community.qlik.com/t5/QlikView/Can-any-one-explan-substing-count-concatinate-functions/m-p/776496#M1021633 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In this expression, the Concat() function will concatenate all the selected or possible Dimension_List_Ord values separating them with a Pipe (for example, Dimension_List_Ord | Dimension_List_Ord | Dimension_List_Ord ).&nbsp; The Substringcount() function will then check that string and will return the number of times that "a" is in that string.&nbsp; </P><P></P><P></P><P>Please refer the attached file.</P></BODY></HTML> Tue, 24 Mar 2015 07:42:02 GMT https://community.qlik.com/t5/QlikView/Can-any-one-explan-substing-count-concatinate-functions/m-p/776496#M1021633 sagarkharpude 2015-03-24T07:42:02Z