topic Counting Text Fields in Column in QlikView https://community.qlik.com/t5/QlikView/Counting-Text-Fields-in-Column/m-p/672619#M1057621 <HTML><HEAD></HEAD><BODY><P>In my Excel source on Incidents, I have a column called "Harm". I want a bar chart created when&nbsp; Harm = yes since there are yes and no values in that column. I want to get the count of 'yes' values only. Please let me know how the expression should be. Thanks</P></BODY></HTML> Tue, 21 Oct 2014 23:44:07 GMT 2014-10-21T23:44:07Z Counting Text Fields in Column https://community.qlik.com/t5/QlikView/Counting-Text-Fields-in-Column/m-p/672619#M1057621 <HTML><HEAD></HEAD><BODY><P>In my Excel source on Incidents, I have a column called "Harm". I want a bar chart created when&nbsp; Harm = yes since there are yes and no values in that column. I want to get the count of 'yes' values only. Please let me know how the expression should be. Thanks</P></BODY></HTML> Tue, 21 Oct 2014 23:44:07 GMT https://community.qlik.com/t5/QlikView/Counting-Text-Fields-in-Column/m-p/672619#M1057621 2014-10-21T23:44:07Z Re: Counting Text Fields in Column https://community.qlik.com/t5/QlikView/Counting-Text-Fields-in-Column/m-p/672620#M1057622 <HTML><HEAD></HEAD><BODY><P>Sorry I want to get the count when Harm = yes.</P></BODY></HTML> Tue, 21 Oct 2014 23:46:03 GMT https://community.qlik.com/t5/QlikView/Counting-Text-Fields-in-Column/m-p/672620#M1057622 2014-10-21T23:46:03Z Re: Counting Text Fields in Column https://community.qlik.com/t5/QlikView/Counting-Text-Fields-in-Column/m-p/672621#M1057623 <HTML><HEAD></HEAD><BODY><P>Sum ( if( Harm='yes', 1,0))</P><P></P><P>or</P><P></P><P>substringcount( concat( Harm,',') , 'yes')</P></BODY></HTML> Wed, 22 Oct 2014 00:35:10 GMT https://community.qlik.com/t5/QlikView/Counting-Text-Fields-in-Column/m-p/672621#M1057623 JonnyPoole 2014-10-22T00:35:10Z Re: Counting Text Fields in Column https://community.qlik.com/t5/QlikView/Counting-Text-Fields-in-Column/m-p/672622#M1057624 <HTML><HEAD></HEAD><BODY><P>Thanks Jonathan It worked</P></BODY></HTML> Wed, 22 Oct 2014 00:51:03 GMT https://community.qlik.com/t5/QlikView/Counting-Text-Fields-in-Column/m-p/672622#M1057624 2014-10-22T00:51:03Z