word clouds

[#1]

Hi all,

Sites such as http://www.wordle.net/ allow you to post text to their URL and generate a word cloud image (where the more common words show up in bigger fonts).

I would like to know if its possible to pass this URL some text from within qlikview and to then display the resultant image within a qlikview document. If the word cloud could change as selections are made within qlikview that would be great.

Any help appreciated.

Thanks

Dan

[johnw]

This isn't at all what you're asking for, but as a possible alternative if you can't do it the pretty way, here's a word count example, and a table showing the top 5 words. The tables are sensitive to selections. Heh, Wordle is caps sensitive. My example is intentionally not.

[#3]

Thanks John.

[johnw]

Heh. While I appreciate it, you might want to unverify my answer. If people see that, they're likely to assume your problem has been solved, and not even look at the thread. There probably IS a way to do what you want; I just don't have much experience with having QlikView interact with web sites.

Anyone have an idea how to do this?

[#5]

Hi

It's a very good idea to integrate Wordle into QV.

There is no API in Wordle, so you can't access to the result in an easy way.

Maybe it's possible to create a macro in JavaScript sending a request to Wordle.net passing the TEXT with the appropriate filter.

Then embedded the result in QV. Maybe with the version 10 of QV you could achieve this (have a look with QV extension), I'm not a specialist.

This the Wordle of What's new in QV 10

regards

JJ

[#6]

Hi, see here: http://community.qlik.com/media/p/152355.aspx for a word clod done in QlikView . Script has similar logic to the sample submitted by John.

-Alex

[johnw]

I haven't played with the version 10 extensions, but I thought I remembered reading word clouds as one of the nice things you could do with them. I believe you can use them to embed a web page in the document, but there may be an even better way to handle it. I just don't have any experience with the extensions yet, so can't say HOW you'd do it, only that it should now be doable cleanly.

Edit: Heh, now that I'm looking more closely, Alex, I see that your example mentions that an advantage to your approach is that it doesn't require external web sites or extensions. Are extensions an issue? I read there could be performance problems if you had a high volume of data, as you perhaps might with some word clouds. Anything else?

[#8]

Hi,

The readme for extensions clearly states that they are supposed to work up to 10 000 items. Well, all Gutenberg corpus contains about 2 and half million words. The scatter chart is able to find the top 20 and render it on a slow single-core Celeron laptop.

Other possibilities with word clouds would be to do a ServerSideExportEx of the top 20 words + frequencies to a folder; have a separate web application that reads the file and produces a PNG file; a macro that calls the ServerSideExportEx and refreshes the picture background of a chart. Like the Google Maps demo. And preferably a scatter chart on top, so you could select with the mouse on the chart. Bonus is to get back the X and Y coordinates into the scatter chart from the word cloud.

So I stopped at the scatter chart

-Alex

[#9]

Hi,

I know this may come a little too late, but its worth the try.

I've uploaded a file which you can find here http://community.qlik.com/media/p/172170.aspx that has a solution for viewing word clouds using extensions and wordle.

I used the qvw posted by John with a small fragment of Project Gutenberg eBook: The Count of Monte Cristo to make the tests.

Hope it helps

Regards.

[#10]

Hi Alex,

I was reading this post and I found it interesting, but I'd like to ask you a question.

What do you mean when you say: "And preferably a scatter chart on top, so you could select with the mouse on the chart. Bonus is to get back the X and Y coordinates into the scatter chart from the word cloud."

Are you able to get back X and Y coordinates of every point you go on top with the mouse on the chart?

What I'm trying to do is to get X and Y values that I point on my scatter chart.

More specifically I need to get the X and Y values I see in the bottom left corner of QlikView.

In the attached image I want to get back the value highlighted in red.

Thanks in advance, best regards.

Mario Masciulli