Sometimes data comes in a free text format, customer comments and feedback are a great example. Here we have a wealth of information a company could harvest and dashboard in QlikView although because it’s free text is becomes difficult to summarise.
This code reads each comment field and searches it for a key word or phrase and counts the occurrences.
Key Words / Phrases
Free Text Comment Field
Due to the fact its reading each possible word or phrase and reloading the comments each time this process could take a while the more data you have although typically comment type fields are small volumes. I would also use an incremental QVD builder to ensure I’m only transforming new data once.