topic Re: contribution in QlikView https://community.qlik.com/t5/QlikView/contribution/m-p/843799#M296434 <HTML><HEAD></HEAD><BODY><P>Is the column D some kind of Customer ID?</P></BODY></HTML> Tue, 28 Apr 2015 16:47:24 GMT petter 2015-04-28T16:47:24Z contribution https://community.qlik.com/t5/QlikView/contribution/m-p/843796#M296431 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I would like to show the count of customers whose contribution is greater than 20 %&nbsp; in a text object how can I get it.</P><P></P><P>Regards</P><P>John</P></BODY></HTML> Tue, 28 Apr 2015 16:17:38 GMT https://community.qlik.com/t5/QlikView/contribution/m-p/843796#M296431 2015-04-28T16:17:38Z Re: contribution https://community.qlik.com/t5/QlikView/contribution/m-p/843797#M296432 <HTML><HEAD></HEAD><BODY><P>can you please share some data?</P></BODY></HTML> Tue, 28 Apr 2015 16:25:14 GMT https://community.qlik.com/t5/QlikView/contribution/m-p/843797#M296432 prma7799 2015-04-28T16:25:14Z Re: contribution https://community.qlik.com/t5/QlikView/contribution/m-p/843798#M296433 <HTML><HEAD></HEAD><BODY><P>Hi Prashant</P><P>PFA. Thanks.</P><P></P><P>Regards</P><P>John</P></BODY></HTML> Tue, 28 Apr 2015 16:38:47 GMT https://community.qlik.com/t5/QlikView/contribution/m-p/843798#M296433 2015-04-28T16:38:47Z Re: contribution https://community.qlik.com/t5/QlikView/contribution/m-p/843799#M296434 <HTML><HEAD></HEAD><BODY><P>Is the column D some kind of Customer ID?</P></BODY></HTML> Tue, 28 Apr 2015 16:47:24 GMT https://community.qlik.com/t5/QlikView/contribution/m-p/843799#M296434 petter 2015-04-28T16:47:24Z Re: contribution https://community.qlik.com/t5/QlikView/contribution/m-p/843800#M296435 <HTML><HEAD></HEAD><BODY><P>Try this example; it will display top 2 customers.</P><P>Perhaps you can modify it to show top 20%.</P><P>By changing this portion;&nbsp; Sum(Sale) to a percent calculation</P><P></P><P><SPAN style="color: #333333; font-family: Lato, Arial; font-size: 15px; text-align: justify;"><STRONG>=concat ( IF( aggr ( Rank(sum(Sale)),<STRONG style="color: #333333; font-family: Lato, Arial; font-size: 15px; text-align: justify;">CustomerID</STRONG>)&lt;=2, CustomerID &amp; chr(10)))</STRONG></SPAN></P></BODY></HTML> Tue, 28 Apr 2015 16:59:25 GMT https://community.qlik.com/t5/QlikView/contribution/m-p/843800#M296435 b_garside 2015-04-28T16:59:25Z Re: contribution https://community.qlik.com/t5/QlikView/contribution/m-p/843801#M296436 <HTML><HEAD></HEAD><BODY><P>Yes</P></BODY></HTML> Tue, 28 Apr 2015 17:00:54 GMT https://community.qlik.com/t5/QlikView/contribution/m-p/843801#M296436 2015-04-28T17:00:54Z