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: 
Not applicable

How to Create a bar chart with the result of a keyword search

i have a Comments column. Need to report on the count of the particular keyword used.

Eg,

Ordered date Product ID Comment

1/1/2009 BRD123 Product returned due to defect

1/1/2009 BRD234 Pricematch given for the product

1/1/2009 BRD455 Customer not satisfied with the product

1/1/2009 BRD123 Product returned due to defect

i need to report on the number of times word "Defect" is used in the comments column and also the percentage of the word defect in comparision to the total comments.

13 Replies
johnw
Champion III
Champion III

Maybe I missed something, but why wouldn't we just create a "keyword" field and have them select keywords just like they select anything else? Then use "keyword" as your dimension, just like any other dimension? Attached is an example with a bunch of text. I've selected three words, and it's counting how many IDs each of these words appear in, and what percent of the overall number of IDs that represents.

Not applicable
Author

Hi John,

Thanks for the solution.

Is it possible to elimate the prepositions from the list of keywords.

Also can you please explain the purpose of Text map loading

Not applicable
Author

Hi John,

Thanks for the solution.

Is it possible to elimate the prepositions from the list of keywords.

Also can you please explain the purpose of Text map loading

johnw
Champion III
Champion III

The map is so that I get 'QlikView' instead of 'Qlikview'.  The capitalize() function has no idea that the V should be capitalized.  In real applications the list of exceptions is usually much longer.  To not load all words, tell QlikView which words you don't want to use.  For instance:

Prepositions:
LOAD * INLINE [
Preposition
On
As
At
Below

...
];

And then modify the inner join a bit:

INNER JOIN (Words)
LOAD ID, Word
RESIDENT Words
WHERE len(trim(Word))
  AND NOT exists(Preposition,Word)
;

See attached.