Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
marcel_olmo
Partner Ambassador
Partner Ambassador

How to create a Tag chart??

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

page tags.png

Many thanks in advance!!

11 Replies
johnw
Champion III
Champion III

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
Champion III
Champion III

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.