topic Re: Different Use for Word Counts in QlikView https://community.qlik.com/t5/QlikView/Different-Use-for-Word-Counts/m-p/743006#M1053620 <HTML><HEAD></HEAD><BODY><P>Thank you.&nbsp; <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 31 Oct 2014 11:28:56 GMT 2014-10-31T11:28:56Z Different Use for Word Counts https://community.qlik.com/t5/QlikView/Different-Use-for-Word-Counts/m-p/743003#M1053617 <HTML><HEAD></HEAD><BODY><P>Hi. I have a comment field and I need to count the words in the field for each record and enter the count in an adjacent new field in the table named comment_wordcount. My search for something like this returns answers I do not want (such as frequency count of specific words, split comment into separate words and count each word).</P><P>But what I need is, for example, if I have 2 records, each with the comment field, and the comment for record # 1 is "My dog is 8 and has black and brown short hair." the new field comment_wordcount I create for this table would show the value 11; whereas for record #2 the comment "My black cat likes to bite."&nbsp; would show the value 6 in the new comment_wordcount field.</P><P></P><P>Any ideas? Even if you suggest counting the spaces, I would be appreciative. Thanks in advance.</P><P></P><P>Coleman</P></BODY></HTML> Fri, 31 Oct 2014 11:15:11 GMT https://community.qlik.com/t5/QlikView/Different-Use-for-Word-Counts/m-p/743003#M1053617 2014-10-31T11:15:11Z Re: Different Use for Word Counts https://community.qlik.com/t5/QlikView/Different-Use-for-Word-Counts/m-p/743004#M1053618 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Use substringcount like:</P><P>=SubstringCount(Comment, ' ')+1</P><P></P><P>HTH</P><P>Jonathan</P></BODY></HTML> Fri, 31 Oct 2014 11:18:04 GMT https://community.qlik.com/t5/QlikView/Different-Use-for-Word-Counts/m-p/743004#M1053618 jonathandienst 2014-10-31T11:18:04Z Re: Different Use for Word Counts https://community.qlik.com/t5/QlikView/Different-Use-for-Word-Counts/m-p/743005#M1053619 <HTML><HEAD></HEAD><BODY><P>How about something simple like:</P><P></P><P>SubStringCount(Text,' ')+1</P><P></P><P>?</P></BODY></HTML> Fri, 31 Oct 2014 11:22:32 GMT https://community.qlik.com/t5/QlikView/Different-Use-for-Word-Counts/m-p/743005#M1053619 simenkg 2014-10-31T11:22:32Z Re: Different Use for Word Counts https://community.qlik.com/t5/QlikView/Different-Use-for-Word-Counts/m-p/743006#M1053620 <HTML><HEAD></HEAD><BODY><P>Thank you.&nbsp; <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 31 Oct 2014 11:28:56 GMT https://community.qlik.com/t5/QlikView/Different-Use-for-Word-Counts/m-p/743006#M1053620 2014-10-31T11:28:56Z