topic Re: Group by top N in QlikView https://community.qlik.com/t5/QlikView/Group-by-top-N/m-p/1339479#M412765 <HTML><HEAD></HEAD><BODY><P>I think just rearrange a bit?</P><P></P><P style="padding-left: 30px;"><SPAN style="font-family: courier new,courier;">aggr(if(rank(sum(Sales))&lt;=100,'Top 100','Other'),[Customer ID])</SPAN></P></BODY></HTML> Thu, 08 Jun 2017 22:31:16 GMT johnw 2017-06-08T22:31:16Z Group by top N https://community.qlik.com/t5/QlikView/Group-by-top-N/m-p/1339478#M412764 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I want to create a pie chart with my top 100 customers by sales grouped in a slice and rest customers as another slice. And show the percentage of total sales for the two groups. Let's suppose my data have customer ID and sales amount as two fields. Is there a way to create such as pie with chart expression rather than load script?</P><P></P><P>I'm trying to create an dimension like this, but it doesn't work...</P><P>i<SPAN style="color: #0000ff;">f</SPAN>(<SPAN style="color: #0000ff;">rank</SPAN>(<SPAN style="color: #0000ff;">aggr</SPAN>(<SPAN style="color: #0000ff;">sum</SPAN>(<SPAN style="color: #800000;">Sales</SPAN>),<SPAN style="color: #800000;">[Customer ID]</SPAN>))&lt;100,'Top 100','Other') </P><P></P><P>Thanks</P><P></P><P>Yvonne</P></BODY></HTML> Thu, 08 Jun 2017 21:12:46 GMT https://community.qlik.com/t5/QlikView/Group-by-top-N/m-p/1339478#M412764 Anonymous 2017-06-08T21:12:46Z Re: Group by top N https://community.qlik.com/t5/QlikView/Group-by-top-N/m-p/1339479#M412765 <HTML><HEAD></HEAD><BODY><P>I think just rearrange a bit?</P><P></P><P style="padding-left: 30px;"><SPAN style="font-family: courier new,courier;">aggr(if(rank(sum(Sales))&lt;=100,'Top 100','Other'),[Customer ID])</SPAN></P></BODY></HTML> Thu, 08 Jun 2017 22:31:16 GMT https://community.qlik.com/t5/QlikView/Group-by-top-N/m-p/1339479#M412765 johnw 2017-06-08T22:31:16Z