Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bnelson111
Creator
Creator

Finding the highest word count. To identify trends.

As I'm sure most people will have a problem with unstructed text fields, for example some people may write two sentences in a comment field while others 3 words or one. I'm looking a way to interrogate a field which may contain 1 word to 5 sentences or more to try and find the most commonly used words, so that we can attempt to discover failure trends.

For example.

Operator CommentsMachineJob Number
Station 3 problemsPress 112345
Failure on Station issuesPress 223233
Spill on Station Press 13232323
Working hard all day and Station issues.

I want to display counts:-

Station = 4

issues = 2

on = 2

All others count1?

There are 1000's of comments so may be best not to have any fix in the script. Also the keys words will change based on date ranges. Any ideas? Thanks.

1 Solution

Accepted Solutions
MarcoWedel

Hi,

one solution at script level:

QlikCommunity_Thread_123629_Pic1.JPG.jpg

LOAD SubField(PurgeChar([Operator Comments],'.'), ' ') as Word

FROM [http://community.qlik.com/thread/123629]

(html, codepage is 1252, embedded labels, table is @1);

hope this helps

regards

Marco

View solution in original post

5 Replies
maxgro
MVP
MVP

maybe some help in a similar discussion here

word clouds

bnelson111
Creator
Creator
Author

Was hoping to have just a count within qlikview if at all possible.

swuehl
MVP
MVP

Well, John's example in that referenced thread does the word count within QV only, right?

MarcoWedel

Hi,

one solution at script level:

QlikCommunity_Thread_123629_Pic1.JPG.jpg

LOAD SubField(PurgeChar([Operator Comments],'.'), ' ') as Word

FROM [http://community.qlik.com/thread/123629]

(html, codepage is 1252, embedded labels, table is @1);

hope this helps

regards

Marco

bnelson111
Creator
Creator
Author

Brilliant!!! Thanks