Word Cloud Outlook Dimensions and Measures

[KJM]

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.

[ogster1974 · Accepted solution]

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.

[KJM]

Ogster,

Apologies - this worked perfectly and I got very excited and forgot to come back to reply.  Many thanks for this solution!

K.