Word frequency dictionary

[#1]

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

[swuehl]

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

[jagannalla]

Hello,

Try the attached file.

[antose]

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

[jagannalla · Accepted solution]

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

[#6]

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

[#7]

Hi antose,

     Your solution works great too:) Thanks!

Regards,

Xue Bin

[#8]

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