
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Word Cloud Outlook Dimensions and Measures
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.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Ogster,
Apologies - this worked perfectly and I got very excited and forgot to come back to reply. Many thanks for this solution!
K.
