topic Re: Display top 5 words in QlikView https://community.qlik.com/t5/QlikView/Display-top-5-words/m-p/565086#M210878 <HTML><HEAD></HEAD><BODY><P>hi ,</P><P></P><P>Solution works fine. Thank you.</P><P></P><P>But when the comment it self is blank , then we will get&nbsp; empty words.</P><P>How can we solve this.</P><P>Because, there are some empty comment in database.</P><P></P><P>Thanks in advance</P></BODY></HTML> Tue, 29 Apr 2014 07:27:14 GMT 2014-04-29T07:27:14Z Display top 5 words https://community.qlik.com/t5/QlikView/Display-top-5-words/m-p/565083#M210875 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>How can we display top words from the list of sentences.</P><P>For example:</P><P></P><P>I have list of comments as below:</P><P></P><P><SPAN style="font-size: 10.0pt; font-family: 'Verdana','sans-serif'; color: #1f497d;">Nice collection of designer wears <SPAN style="font-size: 10.0pt; font-family: 'Verdana','sans-serif'; color: #1f497d;">Paris</SPAN>…</SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Verdana','sans-serif'; color: #1f497d;">Sure, but nothing to beat <SPAN style="font-size: 10.0pt; font-family: 'Verdana','sans-serif'; color: #1f497d;">collection </SPAN>Donna Karen Gucci, Prada…</SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Verdana','sans-serif'; color: #1f497d;">Yeah, but my all-time favorites are Christian Dior, Versace, Vivienne Westwood!!</SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Verdana','sans-serif'; color: #1f497d;">Has anyone checked <SPAN style="font-size: 10.0pt; font-family: 'Verdana','sans-serif'; color: #1f497d;">collection </SPAN>out the latest iPhone???</SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Verdana','sans-serif'; color: #1f497d;">Sorry… not the iPhone types….BlackBerry loyalist…. </SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Verdana','sans-serif'; color: #1f497d;">Heyyyy… just back from Paris… … amazing stay at Bordeaux… the vineyards…</SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Verdana','sans-serif'; color: #1f497d;">Parlez-vous français???</SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Verdana','sans-serif'; color: #1f497d;">Oui…</SPAN></P><P></P><P>Now i want to get the words which are most frequently used among these comments.</P><P></P><P><SPAN style="color: #1f497d; font-size: 10.0pt; font-family: 'Verdana','sans-serif';">collection </SPAN></P><P><SPAN style="color: #1f497d; font-size: 10.0pt; font-family: 'Verdana','sans-serif';">Paris&nbsp; etc..</SPAN></P><P><SPAN style="color: #1f497d; font-size: 10.0pt; font-family: 'Verdana','sans-serif';"><BR /></SPAN></P><P><SPAN style="color: #1f497d; font-size: 10.0pt; font-family: 'Verdana','sans-serif';">Thanks in advance.</SPAN></P></BODY></HTML> Mon, 28 Apr 2014 06:53:42 GMT https://community.qlik.com/t5/QlikView/Display-top-5-words/m-p/565083#M210875 2014-04-28T06:53:42Z Re: Display top 5 words https://community.qlik.com/t5/QlikView/Display-top-5-words/m-p/565084#M210876 <HTML><HEAD></HEAD><BODY><P>See attached qvw.</P></BODY></HTML> Mon, 28 Apr 2014 16:59:08 GMT https://community.qlik.com/t5/QlikView/Display-top-5-words/m-p/565084#M210876 Gysbert_Wassenaar 2014-04-28T16:59:08Z Re: Display top 5 words https://community.qlik.com/t5/QlikView/Display-top-5-words/m-p/565085#M210877 <HTML><HEAD></HEAD><BODY><P>see here,answer from martha</P><P><A href="https://community.qlik.com/message/193811">Word Clouds</A></P></BODY></HTML> Mon, 28 Apr 2014 17:22:21 GMT https://community.qlik.com/t5/QlikView/Display-top-5-words/m-p/565085#M210877 maxgro 2014-04-28T17:22:21Z Re: Display top 5 words https://community.qlik.com/t5/QlikView/Display-top-5-words/m-p/565086#M210878 <HTML><HEAD></HEAD><BODY><P>hi ,</P><P></P><P>Solution works fine. Thank you.</P><P></P><P>But when the comment it self is blank , then we will get&nbsp; empty words.</P><P>How can we solve this.</P><P>Because, there are some empty comment in database.</P><P></P><P>Thanks in advance</P></BODY></HTML> Tue, 29 Apr 2014 07:27:14 GMT https://community.qlik.com/t5/QlikView/Display-top-5-words/m-p/565086#M210878 2014-04-29T07:27:14Z