topic Re: =SubStringCount('|' & Concat(distinct Dimension, '|') & '|', '|Company|') in QlikView https://community.qlik.com/t5/QlikView/SubStringCount-Concat-distinct-Dimension-Company/m-p/697184#M1073812 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>Concat(distinct dimension, '|') - gives the unique dimensions concatenate by pipe symbol.</P><P>SubstringCount() - gives the number of occurrance of substring matches in the string.</P></BODY></HTML> Fri, 01 Aug 2014 09:56:09 GMT MayilVahanan 2014-08-01T09:56:09Z =SubStringCount('|' & Concat(distinct Dimension, '|') & '|', '|Company|') https://community.qlik.com/t5/QlikView/SubStringCount-Concat-distinct-Dimension-Company/m-p/697183#M1073811 <HTML><HEAD></HEAD><BODY><P>=SubStringCount('|' &amp; Concat(distinct Dimension, '|') &amp; '|', '|Company|')</P><P></P><P></P><P>how it works can anybody explain me </P></BODY></HTML> Fri, 01 Aug 2014 09:50:01 GMT https://community.qlik.com/t5/QlikView/SubStringCount-Concat-distinct-Dimension-Company/m-p/697183#M1073811 2014-08-01T09:50:01Z Re: =SubStringCount('|' & Concat(distinct Dimension, '|') & '|', '|Company|') https://community.qlik.com/t5/QlikView/SubStringCount-Concat-distinct-Dimension-Company/m-p/697184#M1073812 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>Concat(distinct dimension, '|') - gives the unique dimensions concatenate by pipe symbol.</P><P>SubstringCount() - gives the number of occurrance of substring matches in the string.</P></BODY></HTML> Fri, 01 Aug 2014 09:56:09 GMT https://community.qlik.com/t5/QlikView/SubStringCount-Concat-distinct-Dimension-Company/m-p/697184#M1073812 MayilVahanan 2014-08-01T09:56:09Z