https://community.qlik.com/t5/QlikView/Count-if-Substring-Number-True/m-p/1593090#M738103 =Count({&lt;C_code= {"=left(C_code,1) = 3"}&gt;}[C_code]) Tue, 18 Jun 2019 13:24:14 GMT Frank_Hartmann 2019-06-18T13:24:14Z https://community.qlik.com/t5/QlikView/Count-if-Substring-Number-True/m-p/1593084#M738102 <P>In My below expression for chart , i need to count the column "c_code" only if the first digit is a 3 , please help me with the syntax. The column has values such as "321" or "3-2-1"&nbsp;</P><P>=Count({&lt;left(C_code,1)={$(3)}&gt;}[C_code])</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Count-if-Substring-Number-True/m-p/1593084#M738102 qlikvw2019 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Count-if-Substring-Number-True/m-p/1593090#M738103 =Count({&lt;C_code= {"=left(C_code,1) = 3"}&gt;}[C_code]) Tue, 18 Jun 2019 13:24:14 GMT https://community.qlik.com/t5/QlikView/Count-if-Substring-Number-True/m-p/1593090#M738103 Frank_Hartmann 2019-06-18T13:24:14Z https://community.qlik.com/t5/QlikView/Count-if-Substring-Number-True/m-p/1593117#M738104 <P>Thankyou!</P> Tue, 18 Jun 2019 13:53:59 GMT https://community.qlik.com/t5/QlikView/Count-if-Substring-Number-True/m-p/1593117#M738104 qlikvw2019 2019-06-18T13:53:59Z