topic Re: TOP Shoppers Report in Management & Governance https://community.qlik.com/t5/Management-Governance/TOP-Shoppers-Report/m-p/92098#M1523 <HTML><HEAD></HEAD><BODY><P>Try like this:</P><P>=if(aggr(Rank(Sum(Sales)),Product) &lt;=100, Product,Null())</P><P>or</P><P>=aggr(if(rank((sales))&lt;=100,Product,'Others'),name) </P><P>or</P><P>=Sum({&lt;Customer = {'=Rank(Sum(Sales))&lt;=100'}&gt;} Sales)</P></BODY></HTML> Thu, 16 Aug 2018 13:27:45 GMT BalaBhaskar_Qlik 2018-08-16T13:27:45Z TOP Shoppers Report https://community.qlik.com/t5/Management-Governance/TOP-Shoppers-Report/m-p/92096#M1521 <HTML><HEAD></HEAD><BODY><P>Good Morning guys,</P><P></P><P>I am trying to get a report for Top 100 shoppers and i used Dimension Limits but its not showing the accurate result.</P><P>Is there a formula i can use for top shopper apart from Dimension limits</P><P></P><P>Await Ideas Please</P></BODY></HTML> Thu, 16 Aug 2018 10:57:05 GMT https://community.qlik.com/t5/Management-Governance/TOP-Shoppers-Report/m-p/92096#M1521 oseimuduame 2018-08-16T10:57:05Z Re: TOP Shoppers Report https://community.qlik.com/t5/Management-Governance/TOP-Shoppers-Report/m-p/92097#M1522 <HTML><HEAD></HEAD><BODY><P>You can try to <SPAN lang="en">achieve it by using rank() function in calculated dimension</SPAN></P><P>=Aggr(</P><P>&nbsp;&nbsp;&nbsp; If(Rank(</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Aggr(</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;yor expression here&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; , [Your Field])</P><P>&nbsp;&nbsp;&nbsp; , 1, 0) &lt;= 100,</P><P>&nbsp;&nbsp;&nbsp; [Your Field] )</P><P>, [Your Field] )</P></BODY></HTML> Thu, 16 Aug 2018 11:22:33 GMT https://community.qlik.com/t5/Management-Governance/TOP-Shoppers-Report/m-p/92097#M1522 Anonymous 2018-08-16T11:22:33Z Re: TOP Shoppers Report https://community.qlik.com/t5/Management-Governance/TOP-Shoppers-Report/m-p/92098#M1523 <HTML><HEAD></HEAD><BODY><P>Try like this:</P><P>=if(aggr(Rank(Sum(Sales)),Product) &lt;=100, Product,Null())</P><P>or</P><P>=aggr(if(rank((sales))&lt;=100,Product,'Others'),name) </P><P>or</P><P>=Sum({&lt;Customer = {'=Rank(Sum(Sales))&lt;=100'}&gt;} Sales)</P></BODY></HTML> Thu, 16 Aug 2018 13:27:45 GMT https://community.qlik.com/t5/Management-Governance/TOP-Shoppers-Report/m-p/92098#M1523 BalaBhaskar_Qlik 2018-08-16T13:27:45Z