How to create a Tag chart??

[marcel_olmo]

Hey guys, does anyone know how to create a chart like this in Qlikview ??

Many thanks in advance!!

[johnw]

gchampion wrote:

The previous version doubles words when a word appears more than one time in a sentence (line of data) because of the autojoin.

Oops!  I can't believe I didn't catch that.  At least SOMEONE caught it.    I think the best solution is a preceding load.

Words:
LOAD *
WHERE len(trim(Word))
;
LOAD ID, mapsubstring('TextMap',subfield(capitalize(keepchar(upper(Text),'ABCDEFGHIJKLMNOPQRSTUVWXYZ ')),' ')) as Word
RESIDENT Data
;

[johnw]

D V wrote:

Thank you John. But I am struggling to open these files. Please can you help?

I have no idea what problem you're having, or how I can help.