topic Re: Display top words in QlikView

Display top words

Mon, 28 Apr 2014 06:32:53 GMT

Hi,

How can we display top words from the list of sentences.

For example:

I have list of comments as below:

Nice collection of designer wears Paris…

Sure, but nothing to beat collection Donna Karen Gucci, Prada…

Yeah, but my all-time favorites are Christian Dior, Versace, Vivienne Westwood!!

Has anyone checked collection out the latest iPhone???

Sorry… not the iPhone types….BlackBerry loyalist….

Heyyyy… just back from Paris… … amazing stay at Bordeaux… the vineyards…

Parlez-vous français???

Oui…

Now i want to get the words which are most frequently used among these comments.

collection

Paris etc..

Thanks in advance.

swuehl — Mon, 28 Apr 2014 17:22:42 GMT

Have a look at this thread

and there is also a similar app called word cloud or similar in the document section.

In additition, there are also extensions for word clouds, e.g. Word Cloud Object Extension

Regards,

Stefan

maxgro — Tue, 29 Apr 2014 20:51:33 GMT

Wed, 30 Apr 2014 06:00:40 GMT

Hi,

Extension will work only on ajax mode,since i have macros written in my dashboard,I can not go for extension.

Thank u

maxgro — Wed, 30 Apr 2014 18:49:01 GMT

I think you can find some help here (no extension)

swuehl — Wed, 30 Apr 2014 19:07:47 GMT

The first linked thread in my post shows a QV script based solution only, no extensions needed.

Clever_Anjos — Wed, 30 Apr 2014 19:36:08 GMT

Maybe this?

PFA