topic top N rows in a pivot in QlikView https://community.qlik.com/t5/QlikView/top-N-rows-in-a-pivot/m-p/367550#M1176561 <HTML><HEAD></HEAD><BODY><P> Hi,</P><P></P><P>Then you can either use a calculated dimension using Aggr(). Obviously, it will perform not so fast handling huge data volumes i.e.:</P><P></P><P><CODE class="jive-code">=If(Aggr(Rank(Sum(Field3), 4, 1), Field1) &lt; 6, Field1)</CODE></P><P></P><P>In this case you should have to check the "Supress when value is null" in the Dimensions tab</P><P></P><P>Hope that helps.</P><P></P><P>Miguel</P></BODY></HTML> Wed, 25 Apr 2012 11:25:05 GMT Miguel_Angel_Baeyens 2012-04-25T11:25:05Z top N rows in a pivot https://community.qlik.com/t5/QlikView/top-N-rows-in-a-pivot/m-p/367546#M1176557 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I need to implement a pivot table such that only top 50 rows based upon a third column(not been displayed in the table). Please help me in achieving this.</P><P></P><P></P><P>Thanks in advance</P></BODY></HTML> Wed, 25 Apr 2012 10:53:40 GMT https://community.qlik.com/t5/QlikView/top-N-rows-in-a-pivot/m-p/367546#M1176557 sonikajain 2012-04-25T10:53:40Z top N rows in a pivot https://community.qlik.com/t5/QlikView/top-N-rows-in-a-pivot/m-p/367547#M1176558 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Are you using version 11? If so, use the Dimension Limits tab in the chart properties, to select those 50 "biggest something".</P><P></P><P>Hope that helps.</P><P></P><P>Miguel</P></BODY></HTML> Wed, 25 Apr 2012 11:01:07 GMT https://community.qlik.com/t5/QlikView/top-N-rows-in-a-pivot/m-p/367547#M1176558 Miguel_Angel_Baeyens 2012-04-25T11:01:07Z top N rows in a pivot https://community.qlik.com/t5/QlikView/top-N-rows-in-a-pivot/m-p/367548#M1176559 <HTML><HEAD></HEAD><BODY><P>I don't think you can restrict row numbers in Pivot table, better use a Straight table.</P><P>May be you can use some calculated dimension for top 10 people or something like that.</P></BODY></HTML> Wed, 25 Apr 2012 11:12:12 GMT https://community.qlik.com/t5/QlikView/top-N-rows-in-a-pivot/m-p/367548#M1176559 suniljain 2012-04-25T11:12:12Z top N rows in a pivot https://community.qlik.com/t5/QlikView/top-N-rows-in-a-pivot/m-p/367549#M1176560 <HTML><HEAD></HEAD><BODY><P> dimention Limit tab is available in straight table . not in pivot table.</P></BODY></HTML> Wed, 25 Apr 2012 11:14:29 GMT https://community.qlik.com/t5/QlikView/top-N-rows-in-a-pivot/m-p/367549#M1176560 suniljain 2012-04-25T11:14:29Z top N rows in a pivot https://community.qlik.com/t5/QlikView/top-N-rows-in-a-pivot/m-p/367550#M1176561 <HTML><HEAD></HEAD><BODY><P> Hi,</P><P></P><P>Then you can either use a calculated dimension using Aggr(). Obviously, it will perform not so fast handling huge data volumes i.e.:</P><P></P><P><CODE class="jive-code">=If(Aggr(Rank(Sum(Field3), 4, 1), Field1) &lt; 6, Field1)</CODE></P><P></P><P>In this case you should have to check the "Supress when value is null" in the Dimensions tab</P><P></P><P>Hope that helps.</P><P></P><P>Miguel</P></BODY></HTML> Wed, 25 Apr 2012 11:25:05 GMT https://community.qlik.com/t5/QlikView/top-N-rows-in-a-pivot/m-p/367550#M1176561 Miguel_Angel_Baeyens 2012-04-25T11:25:05Z