Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I have used the Outlook Connector to bring in the data from my Inbox.
I would like to create a Word Cloud from the Qlik Vis Bundle but I can't seem to get the Dimension and Meaure correct.
Would anyone know what I should be trying. I have include a snip of the field names from the model viewer.
For instance, I tried using message_id as the dimension and Sum(bodypreview) as the measure but that didn't work.
Thanks,
K.
Ok so first things first you're gonna need to prep your data for use in the word cloud.
for this you need a dimension with each word you want to visualise and a counter for identifying the number of times it occurs.
so lets assume you are interested in subject header.
create a new table with the following.
SubjectWords:
LOAD
1 as WordCount,
message_id,
SubField("subject",' ') as Word
Resident Messages
;
This will seperate table with the dimension and measure you need for your visual.
The plug the word and word count into your word cloud. example below I did with Product description.
So I can see Best is the most common word in my product catalog.
Ok so first things first you're gonna need to prep your data for use in the word cloud.
for this you need a dimension with each word you want to visualise and a counter for identifying the number of times it occurs.
so lets assume you are interested in subject header.
create a new table with the following.
SubjectWords:
LOAD
1 as WordCount,
message_id,
SubField("subject",' ') as Word
Resident Messages
;
This will seperate table with the dimension and measure you need for your visual.
The plug the word and word count into your word cloud. example below I did with Product description.
So I can see Best is the most common word in my product catalog.
Ogster,
Apologies - this worked perfectly and I got very excited and forgot to come back to reply. Many thanks for this solution!
K.