Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
chaorenzhu
Creator II
Creator II

Word cloud when a word has been selected

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. 

Labels (3)
1 Solution

Accepted Solutions
chaorenzhu
Creator II
Creator II
Author

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

View solution in original post

3 Replies
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

Great dreamer's dreams never fulfilled, they are always transcended.
chaorenzhu
Creator II
Creator II
Author

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
Creator II
Creator II
Author

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