Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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
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