topic word cloud in QlikView https://community.qlik.com/t5/QlikView/word-cloud/m-p/650472#M237919 <HTML><HEAD></HEAD><BODY><P style="text-align: left;">hi group,</P><P></P><P style="text-align: left;">I have data as below.</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 294px;"><TBODY><TR><TD class="xl65" height="20" width="98">apn</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="98">handset</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="98">Count(DISTINCT<BR />&nbsp; cust_id)</TD></TR><TR><TD class="xl66" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;"> </TD><TD class="xl66" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;"> </TD><TD align="right" class="xl67" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">9800</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">4G</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Nexus 4</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">571</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">3G</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Nexus 4</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">567</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2G</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Nexus 4</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">566</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">GPRS</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Nexus 4</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">565</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">4G</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Lumia 720</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">386</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">GPRS</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Nexus 3</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">383</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2G</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Lumia 520</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">381</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">3G</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Lumia 720</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">381</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">GPRS</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Lumia 720</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">381</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">4G</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Lumia 520</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">380</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">3G</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Lumia 520</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">379</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2G</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Nexus 3</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">378</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">GPRS</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Lumia 520</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">377</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">4G</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Nexus 3</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">375</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2G</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Lumia 720</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">374</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">3G</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Nexus 3</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">372</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">3G</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Lumia 620</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">198</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">GPRS</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Xperia U</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">197</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">3G</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">desire X</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">196</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">3G</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Galaxy S3</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">196</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">4G</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">One Max</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">196</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2G</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Xperia U</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">196</TD></TR></TBODY></TABLE><P></P><P>i want to create a word cloud object with dimension as handset.</P><P>measurement -- customercount.</P><P>color--apn</P><P></P><P>I am able to do this. But my problem is i want to get the top handsets for which customercount is maximum based on apn.</P><P>Something like below.</P><P></P><P></P><P> nexus4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4g&nbsp;&nbsp;&nbsp; 571</P><P>lumia720&nbsp;&nbsp; gprs&nbsp;&nbsp; 381</P><P>nexus3&nbsp;&nbsp;&nbsp; gprs&nbsp; 378</P><P>lumia520&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2g&nbsp;&nbsp;&nbsp;&nbsp; 381</P><P></P><P>and so on.. please help me how to achieve this</P></BODY></HTML> Fri, 25 Jul 2014 08:22:46 GMT 2014-07-25T08:22:46Z word cloud https://community.qlik.com/t5/QlikView/word-cloud/m-p/650472#M237919 <HTML><HEAD></HEAD><BODY><P style="text-align: left;">hi group,</P><P></P><P style="text-align: left;">I have data as below.</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 294px;"><TBODY><TR><TD class="xl65" height="20" width="98">apn</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="98">handset</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="98">Count(DISTINCT<BR />&nbsp; cust_id)</TD></TR><TR><TD class="xl66" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;"> </TD><TD class="xl66" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;"> </TD><TD align="right" class="xl67" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">9800</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">4G</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Nexus 4</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">571</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">3G</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Nexus 4</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">567</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2G</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Nexus 4</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">566</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">GPRS</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Nexus 4</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">565</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">4G</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Lumia 720</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">386</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">GPRS</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Nexus 3</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">383</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2G</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Lumia 520</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">381</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">3G</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Lumia 720</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">381</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">GPRS</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Lumia 720</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">381</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">4G</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Lumia 520</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">380</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">3G</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Lumia 520</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">379</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2G</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Nexus 3</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">378</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">GPRS</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Lumia 520</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">377</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">4G</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Nexus 3</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">375</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2G</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Lumia 720</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">374</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">3G</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Nexus 3</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">372</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">3G</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Lumia 620</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">198</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">GPRS</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Xperia U</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">197</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">3G</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">desire X</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">196</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">3G</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Galaxy S3</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">196</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">4G</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">One Max</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">196</TD></TR><TR><TD class="xl68" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2G</TD><TD class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Xperia U</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">196</TD></TR></TBODY></TABLE><P></P><P>i want to create a word cloud object with dimension as handset.</P><P>measurement -- customercount.</P><P>color--apn</P><P></P><P>I am able to do this. But my problem is i want to get the top handsets for which customercount is maximum based on apn.</P><P>Something like below.</P><P></P><P></P><P> nexus4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4g&nbsp;&nbsp;&nbsp; 571</P><P>lumia720&nbsp;&nbsp; gprs&nbsp;&nbsp; 381</P><P>nexus3&nbsp;&nbsp;&nbsp; gprs&nbsp; 378</P><P>lumia520&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2g&nbsp;&nbsp;&nbsp;&nbsp; 381</P><P></P><P>and so on.. please help me how to achieve this</P></BODY></HTML> Fri, 25 Jul 2014 08:22:46 GMT https://community.qlik.com/t5/QlikView/word-cloud/m-p/650472#M237919 2014-07-25T08:22:46Z