topic Re: Counting Substrings in QlikView https://community.qlik.com/t5/QlikView/Counting-Substrings/m-p/460432#M171889 <HTML><HEAD></HEAD><BODY><P>Thanks Miguel but I believe I got it by using:</P><P></P><P>SubStringCount(MultipleValues, ';') + 1</P></BODY></HTML> Tue, 16 Apr 2013 21:57:55 GMT Anonymous 2013-04-16T21:57:55Z Counting Substrings https://community.qlik.com/t5/QlikView/Counting-Substrings/m-p/460431#M171888 <HTML><HEAD></HEAD><BODY><P>I'm trying to count how many substrings are there in one string that contains multiple values separated by ";"</P><P>For example, if field MultipleValues contain "ab;ac;ad;ef"</P><P>I should get 4 back.</P><P></P><P>I tried doing:</P><P></P><P>GetSelectedCount(MultipleValues, Subfield(MulitipleValues, ';'))</P><P>or</P><P>SubStirngCount(MultipleValues, Subfield(MultipleValues, ';'))</P><P></P><P>but didn't get desired results.</P></BODY></HTML> Tue, 16 Apr 2013 20:55:18 GMT https://community.qlik.com/t5/QlikView/Counting-Substrings/m-p/460431#M171888 Anonymous 2013-04-16T20:55:18Z Re: Counting Substrings https://community.qlik.com/t5/QlikView/Counting-Substrings/m-p/460432#M171889 <HTML><HEAD></HEAD><BODY><P>Thanks Miguel but I believe I got it by using:</P><P></P><P>SubStringCount(MultipleValues, ';') + 1</P></BODY></HTML> Tue, 16 Apr 2013 21:57:55 GMT https://community.qlik.com/t5/QlikView/Counting-Substrings/m-p/460432#M171889 Anonymous 2013-04-16T21:57:55Z