Word cloud when a word has been selected

[chaorenzhu]

Hi everyone,

I’m currently developing a word cloud using a list of sentences.  My idea is that when the user select a word from the word cloud, another word cloud can be generated based on all sentences that contain the particular word. Can you advise if this is a achievable in Qlik Sense? Thanks. 

[PrashantSangle]

Not understood your requirement properly, Can you explain with sample data.

i am proposing solution as per my understanding of question

data:
Load RecNo() as recID, lower(SubField(Words,' ')) as word_in_sentence,Words Inline [
Words
A word cloud
there is word
No cloud
];

join

Load Distinct lower(word_in_sentence) as word_in_sentence Resident data;

Regards

[chaorenzhu]

Hi PrashantSangle,

taking your sample data as an example. I have plotted a word cloud using word_in_sentence as dimension and count(word_in_sentence) as measure. Now when I click the word "cloud", another word cloud should be generated using all Words that contain "cloud", i.e. the word cloud should have words "a", "word", "cloud", "no", but doesn't contain "there", "is".

How would I be able to do that? Thanks

[chaorenzhu · Accepted solution]

I have found a walkaround solution

data:
Load RecNo() as recID, lower(SubField(Words,' ')) as word_in_sentence, lower(SubField(Words,' ')) as word_in_sentence2, Words Inline [
Words
A word cloud
there is word
No cloud
];

For the first word cloud just create a normal one, then for the second word cloud, after selecting a word in word_in_sentence, use

word_in_sentence2 as dimension and 

count({<word_in_sentence=>} if(wildmatch(Words,'*$(=getfieldselections(word_in_sentence))*'), word_in_sentence2)) as measure