topic Word frequency dictionary in QlikView

Word frequency dictionary

Tue, 22 May 2012 12:28:28 GMT

Hi,

I have this column called query text shown as below.

QueryText
OMG, Tomorrow is physics exam
OMG, Tomorrow is maths exam
OMG, Tomorrow is economics exam

What I would like to do is to extract each word from this column and do a frequency count of each word. So my output would be

Word	Count
OMG	3
Tomorrow	3
is	3
physics	1
maths	1
economics	1
exam	3

Could anyone tell me is it possible with Qlikview?

Regards,

Xue Bin

Word frequency dictionary

swuehl — Tue, 22 May 2012 12:32:06 GMT

Yes,

please check this tread:

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

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

Regards,

Stefan

Re: Word frequency dictionary

jagannalla — Tue, 22 May 2012 12:41:31 GMT

Hello,

Try the attached file.

Word frequency dictionary

antose — Tue, 22 May 2012 12:43:33 GMT

Try SubField(Replace(QueryText,',', ''), ' ') AS Counter. Then add a listbox and show frequens

Re: Word frequency dictionary

jagannalla — Tue, 22 May 2012 12:44:33 GMT

Hello,

Try the attach file. Otherwise use this code.

LOAD *,Replace(SubField(QueryText,' '),',',' ') as Word;
    LOAD * INLINE [
        QueryText
        "OMG, Tomorrow is physics exam"
        "OMG, Tomorrow is maths exam"
        "OMG, Tomorrow is economics exam"
    ];

- In Straight table take dimension as Word and expression as Count(Word)

I hope it helps you.

Cheers!!!

Word frequency dictionary

Wed, 23 May 2012 03:13:18 GMT

Hi Jagan,

Thanks. And that's very nice of you posting the code here as I don't own a qlikview license:( It works great:)

Regards,

Xue Bin

Word frequency dictionary

Wed, 23 May 2012 03:15:53 GMT

Hi antose,

Your solution works great too:) Thanks!

Regards,

Xue Bin

Re: Word frequency dictionary

Wed, 23 May 2012 03:20:04 GMT

Hi Stefan,

Thanks for pointing me to that post. Could you help me have a look at this problem? I have posted it here but so far nobody replied. In this case, can I assume Qlikview is not capable of doing that?

http://community.qlik.com/message/221441#221441

Regards,

Xue Bin