topic How to Use AGGR functon in QlikView https://community.qlik.com/t5/QlikView/How-to-Use-AGGR-functon/m-p/82204#M768886 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>i have three fields as below</P><P>product name, sale, profit</P><P>now i would like to show the top 10 product name and sales based on Profit.</P><P></P><P>(here i should sort the product names based on profit but should display sum(sales))</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT himabinduch 2020-11-25T16:16:04Z How to Use AGGR functon https://community.qlik.com/t5/QlikView/How-to-Use-AGGR-functon/m-p/82204#M768886 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>i have three fields as below</P><P>product name, sale, profit</P><P>now i would like to show the top 10 product name and sales based on Profit.</P><P></P><P>(here i should sort the product names based on profit but should display sum(sales))</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-Use-AGGR-functon/m-p/82204#M768886 himabinduch 2020-11-25T16:16:04Z Re: How to Use AGGR functon https://community.qlik.com/t5/QlikView/How-to-Use-AGGR-functon/m-p/82205#M768887 <HTML><HEAD></HEAD><BODY><P style="margin-right: 2.85pt; margin-bottom: .85pt; margin-left: 45.0pt;"><STRONG style="font-size: 9.0pt; font-family: 'Courier New';">=if(</STRONG></P><P style="margin-right: 2.85pt; margin-bottom: .85pt; margin-left: 45.0pt;"><STRONG style="font-size: 9.0pt; font-family: 'Courier New';">Aggr(Rank(Sum(Profit)), <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">product name</SPAN>)&lt;=10, </STRONG></P><P style="margin-right: 2.85pt; margin-bottom: .85pt; margin-left: 45.0pt;"><STRONG style="font-size: 9.0pt; font-family: 'Courier New';"><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">product name</SPAN>, </STRONG></P><P style="margin-right: 2.85pt; margin-bottom: .85pt; margin-left: 45.0pt;"><STRONG style="font-size: 9.0pt; font-family: 'Courier New';">'Others'</STRONG></P><P style="margin-right: 2.85pt; margin-bottom: 10.45pt; margin-left: 45.0pt;"><STRONG style="font-size: 9.0pt; font-family: 'Courier New';">)</STRONG></P></BODY></HTML> Mon, 11 Jun 2018 11:05:47 GMT https://community.qlik.com/t5/QlikView/How-to-Use-AGGR-functon/m-p/82205#M768887 Anonymous 2018-06-11T11:05:47Z Re: How to Use AGGR functon https://community.qlik.com/t5/QlikView/How-to-Use-AGGR-functon/m-p/82206#M768888 <HTML><HEAD></HEAD><BODY><P>Or following?</P><P></P><P><STRONG style="font-size: 9.0pt; font-family: 'Courier New';">Dual(Aggr(Rank(Sum(<STRONG style="font-size: 9pt; font-family: 'Courier New'; color: #3d3d3d;">Profit</STRONG>)), Country)&lt;=10,</STRONG><SPAN style="font-size: 10.0pt; font-family: 'Helvetica',sans-serif; color: #3d3d3d; background: white;"> <STRONG style="font-family: 'Helvetica',sans-serif;">product name</STRONG></SPAN><STRONG style="font-size: 9.0pt; font-family: 'Courier New';">,’’),Sum(Sales))</STRONG></P></BODY></HTML> Mon, 11 Jun 2018 11:14:25 GMT https://community.qlik.com/t5/QlikView/How-to-Use-AGGR-functon/m-p/82206#M768888 Anonymous 2018-06-11T11:14:25Z Re: How to Use AGGR functon https://community.qlik.com/t5/QlikView/How-to-Use-AGGR-functon/m-p/82207#M768889 <HTML><HEAD></HEAD><BODY><P>Hi Hima,</P><P></P><P>Please use below Calculated Dimension &amp; Expression.</P><P></P><P><STRONG style="text-decoration: underline;">Calculated Dimension</STRONG>:</P><P>=if(aggr(rank(sum(Profit)),Product)&lt;=10,Product)</P><P></P><P><STRONG style="text-decoration: underline;">Expression</STRONG> :</P><P>Sum(Sales)</P><P></P><P>Regards</P><P>Sumeet</P></BODY></HTML> Mon, 11 Jun 2018 11:30:05 GMT https://community.qlik.com/t5/QlikView/How-to-Use-AGGR-functon/m-p/82207#M768889 sumeet-vaidya 2018-06-11T11:30:05Z