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!!

[IAMDV]

Hi,

I am attaching one of the example which John has created. I have added the TextBox and used the Concat() function to show the distinct words. However, there is no way around to control the FontSize within the TextObject. I hope someone can help you on this...

Here is the example for you reference.

Cheers - DV

[marcel_olmo]

Many thanks D.V. I reported that in the "ideas" folder. I hope someone can listen to us!!

Here's the link  :

http://community.qlik.com/ideas/2134

[IAMDV]

Hey - You are welcome. I wanted to do something similar sometime back. But we have dropped the idea of Word Cloud coz it was impossible with QV. However, I went to see the idea and it says its been deleted. Any idea? Please check the link you posted...

Cheers - DV

[marcel_olmo]

Hey DV, here's what it says :

This idea is awaiting approval and therefore not visible to others still. Only the author or approver can access the same today. Once all approvers approve the idea, be published and made visible.

That's why you can't see it right now.

Cheers!!

[IAMDV]

Cool. Thanks for the prompt update.

[johnw · Accepted solution]

Martha Hernandez posted a working example using extensions and wordle in this thread:

http://community.qlik.com/thread/13654

Unfortunately, the links got lost in the move to the new forum.  Hopefully I have the right files below.  Install the QAR, then open the QVW.  On my machine, though, Windows blocks it, complaining about an unverified publisher, and doesn't give me any option to unblock.  Thanks, Windows!  I've seen it work on an older machine, though.

[#8]

John, just fyi I retrieve martha's thread

http://community.qlik.com/qlikviews/1045#comment-1408

JJ

[gchampion]

You might replace :

Words:

LOAD ID, mapsubstring('TextMap',subfield(capitalize(keepchar(upper(Text),'ABCDEFGHIJKLMNOPQRSTUVWXYZ ')),' ')) as Word

RESIDENT Data

;

INNER JOIN (Words)

LOAD ID, Word

RESIDENT Words

WHERE len(trim(Word))

;

by this

tempWords:

LOAD ID, mapsubstring('TextMap',subfield(capitalize(keepchar(upper(Text),'ABCDEFGHIJKLMNOPQRSTUVWXYZ ')),' ')) as Word

RESIDENT Data

;

Words:

NoConcatenate

LOAD ID, Word

RESIDENT tempWords

WHERE len(trim(Word));

drop Table tempWords;

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

Guc

[IAMDV]

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

Jean-Jacques Jesua - Sorry, I cant open the URL. Please can you check this for me?

Thanks - DV