topic How to create a Tag chart?? in QlikView

How to create a Tag chart??

marcel_olmo — Tue, 15 Nov 2011 12:11:23 GMT

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

Many thanks in advance!!

Re: How to create a Tag chart??

IAMDV — Tue, 15 Nov 2011 12:38:35 GMT

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

How to create a Tag chart??

marcel_olmo — Tue, 15 Nov 2011 15:39:31 GMT

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

Re: How to create a Tag chart??

IAMDV — Tue, 15 Nov 2011 15:42:15 GMT

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

How to create a Tag chart??

marcel_olmo — Tue, 15 Nov 2011 16:23:16 GMT

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

Re: How to create a Tag chart??

IAMDV — Tue, 15 Nov 2011 16:43:20 GMT

Cool. Thanks for the prompt update.

Re: How to create a Tag chart??

johnw — Tue, 15 Nov 2011 18:38:58 GMT

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.

How to create a Tag chart??

Tue, 15 Nov 2011 20:06:39 GMT

John, just fyi I retrieve martha's thread

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

Re: How to create a Tag chart??

gchampion — Wed, 16 Nov 2011 09:21:07 GMT

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

Re: How to create a Tag chart??

IAMDV — Wed, 16 Nov 2011 09:33:17 GMT

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

Re: How to create a Tag chart??

johnw — Wed, 16 Nov 2011 17:16:59 GMT

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
;

Re: How to create a Tag chart??

johnw — Wed, 16 Nov 2011 17:17:56 GMT

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.