Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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!!!
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
Hello,
Try the attached file.
Try SubField(Replace(QueryText,',', ''), ' ') AS Counter. Then add a listbox and show frequens
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!!!
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
Hi antose,
Your solution works great too:) Thanks!
Regards,
Xue Bin
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