topic Re: WordCloud issues in QlikView

WordCloud issues

Wed, 25 Nov 2020 16:16:04 GMT

I have an excel file in the following format:

Date	Client	Issue	Comment
12/16/2016	John Doe	Monitor	Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt.
12/16/2016	John Doe	CPU	Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore.
12/16/2016	John Doe	Keyboard	eu fugiat nulla pariatur.
12/16/2016	John Doe	Mouse	in voluptate velit esse cillum dolore.

In short, I am trying to use the WordCloud extension to find trends in the comments, but I just don't know how to approach it since the extension is taking the full sentences. I want to show the top lets say 50 or 100 words.

Any assistance would be appreciated.

Re: WordCloud issues

Anil_Babu_Samineni — Sat, 17 Dec 2016 16:33:13 GMT

I want to show the top lets say 50 or 100 words.

What you want to show by using the extension. I didn't understand the above part. Can you elaborate more

Re: WordCloud issues

Sat, 17 Dec 2016 17:02:16 GMT

Hi Anil, thanks for the reply.

What I am to show, is trends in the comments. for example:

we log the problem and the solution, but in order to learn about the symptoms, we have to read the comments. However, by being able to pull the "Comment" column into a word cloud, I might be able to find patterns such as, "crashing", "Virus","hard drive", based on the occurrence of that word.

Does this make sense?

When I pull the column now, it gives me a paragraph cloud instead of a wordCloud.

Re: WordCloud issues

Anil_Babu_Samineni — Sat, 17 Dec 2016 17:25:05 GMT

Check this for long sentence fields

https://www.jasondavies.com/wordcloud/#http%3A%2F%2Fsearch.twitter.com%2Fsearch.json%3Frpp%3D100%26q%3D%7Bword%7D=cloud

Re: WordCloud issues

Sat, 17 Dec 2016 17:46:53 GMT

Sorry Anil, maybe is my lack of knowledge, but I dont see how to translate what that site shows to the extension in qlikview. my data updates weekly, and I want to have the wordcloud dynamically update with selections like charts do.

Re: WordCloud issues

Sat, 17 Dec 2016 17:49:51 GMT

Maybe if it was possible to merge all the columns into one block of text, then split it into its separate words, while removing "and" 'of' 'the', etc. maybe this way the extension will be able to display it well <- I just have no clue on how to achieve this.

Re: WordCloud issues

Sat, 17 Dec 2016 17:55:01 GMT

I was thinking of something like =(Concat(

Re: WordCloud issues

Anil_Babu_Samineni — Sat, 17 Dec 2016 17:57:08 GMT

May be, i am not fully understand the expected output

You can use Append if you want to show one and then use that field

I mean this, And then directly Key for WordCloud. You may solve those. Try this way and then use subfield to split into different or concat also can help you

Load Date & Client & Issue & Replace(Comment, 'and*' OR 'of*' OR 'the*', ' ') as Comment as Key;

LOAD * Inline [

Date, Client, Issue, Comment

12/16/2016, John Doe, Monitor, Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt.

12/16/2016, John Doe, CPU, Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore.

12/16/2016, John Doe, Keyboard, eu fugiat nulla pariatur.

12/16/2016, John Doe, Mouse, in voluptate velit esse cillum dolore.

];

Re: WordCloud issues

Sat, 17 Dec 2016 23:27:46 GMT

It seems that the WordCloud extension only works if the words are each in a different cell, am I wrong?

Re: WordCloud issues

Anil_Babu_Samineni — Sun, 18 Dec 2016 08:45:47 GMT

I will continue for more clarity to get idea.

If you have one field of data with longer string it would possible to get diff diff names by using SubField and then use concat to merge those cells into one and then use this. For more idea look this

Word Cloud Object Extension | Qlik Community

OR Check this link how to show wordcloud by using hand work.

Qlikview en Español: WordCloud sin extensiones

Hope this helps to you