topic Re: Aggregation Functions in QlikView https://community.qlik.com/t5/QlikView/Aggregation-Functions/m-p/571544#M1118747 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt; line-height: 1.5em;">See <A href="https://community.qlik.com/docs/DOC-4777">QlikView Technical Brief - AGGR</A> for more information on the AGGR function.</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">The formula you are looking for is:<BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">IF( AGGR( RANK( SUM( sales) ), product) &lt;=5,product)</SPAN></P></BODY></HTML> Wed, 12 Feb 2014 03:20:37 GMT Anonymous 2014-02-12T03:20:37Z Aggregation Functions https://community.qlik.com/t5/QlikView/Aggregation-Functions/m-p/571543#M1118746 <HTML><HEAD></HEAD><BODY><P>hai alllllll</P><P>please Explain about Aggregation Functions with examples.how to find out the top 5 sales in product table and also each category sum,min,max,avg sales......</P><P></P><P></P><P>table fields are&nbsp; category,product,sales like</P></BODY></HTML> Wed, 12 Feb 2014 02:41:11 GMT https://community.qlik.com/t5/QlikView/Aggregation-Functions/m-p/571543#M1118746 2014-02-12T02:41:11Z Re: Aggregation Functions https://community.qlik.com/t5/QlikView/Aggregation-Functions/m-p/571544#M1118747 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt; line-height: 1.5em;">See <A href="https://community.qlik.com/docs/DOC-4777">QlikView Technical Brief - AGGR</A> for more information on the AGGR function.</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">The formula you are looking for is:<BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">IF( AGGR( RANK( SUM( sales) ), product) &lt;=5,product)</SPAN></P></BODY></HTML> Wed, 12 Feb 2014 03:20:37 GMT https://community.qlik.com/t5/QlikView/Aggregation-Functions/m-p/571544#M1118747 Anonymous 2014-02-12T03:20:37Z Re: Aggregation Functions https://community.qlik.com/t5/QlikView/Aggregation-Functions/m-p/571545#M1118748 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try like this</P><P></P><P>Dimension : <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">IF( Aggr( Rank( Sum( Sales), 4 ), <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Product</SPAN>) &lt;=5, Product)</SPAN></P><P></P><P>Expression : Sum(Sales)</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Wed, 12 Feb 2014 04:03:03 GMT https://community.qlik.com/t5/QlikView/Aggregation-Functions/m-p/571545#M1118748 jagan 2014-02-12T04:03:03Z