topic Re: How to show Top20 rows in Pivot table? in QlikView https://community.qlik.com/t5/QlikView/How-to-show-Top20-rows-in-Pivot-table/m-p/475582#M690159 <HTML><HEAD></HEAD><BODY><P>use Sum(Sales) as Expression to your pivot table.</P></BODY></HTML> Wed, 25 Sep 2013 13:15:10 GMT AbhijitBansode 2013-09-25T13:15:10Z How to show Top20 rows in Pivot table? https://community.qlik.com/t5/QlikView/How-to-show-Top20-rows-in-Pivot-table/m-p/475579#M690156 <HTML><HEAD></HEAD><BODY><P>Hello, I need to show top20 products that have maximum sales in a specific period, in a specific time, in a specific shop .. . .<BR />I can do that in Straight table by using the limiting option in dimension tab, but pivot table doesn't allow me to do.<BR />Anyone, can come up with the solution for me? Thanks in advance.</P></BODY></HTML> Wed, 25 Sep 2013 12:06:24 GMT https://community.qlik.com/t5/QlikView/How-to-show-Top20-rows-in-Pivot-table/m-p/475579#M690156 2013-09-25T12:06:24Z Re: How to show Top20 rows in Pivot table? https://community.qlik.com/t5/QlikView/How-to-show-Top20-rows-in-Pivot-table/m-p/475580#M690157 <HTML><HEAD></HEAD><BODY><P>Try using Rank function in calculated dimension:</P><P></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #0000ff; font-size: 10pt;">If</SPAN><SPAN style="font-size: 10pt;">( <SPAN style="color: #0000ff;">Aggr</SPAN>(<SPAN style="color: #0000ff;">Rank</SPAN>(<SPAN style="color: #0000ff;">Sum</SPAN>(<SPAN style="color: #800000;">Sales</SPAN>)),<SPAN style="color: #800000;">&lt;PeriodField&gt;,&lt;ShopField&gt;</SPAN>)&lt;=20,Product)<BR /></SPAN></SPAN></P></BODY></HTML> Wed, 25 Sep 2013 12:33:58 GMT https://community.qlik.com/t5/QlikView/How-to-show-Top20-rows-in-Pivot-table/m-p/475580#M690157 AbhijitBansode 2013-09-25T12:33:58Z Re: How to show Top20 rows in Pivot table? https://community.qlik.com/t5/QlikView/How-to-show-Top20-rows-in-Pivot-table/m-p/475581#M690158 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">If</SPAN><SPAN style="font-size: 10pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">( <SPAN style="font-style: inherit; font-family: inherit; color: #0000ff;">Aggr</SPAN>(<SPAN style="font-style: inherit; font-family: inherit; color: #0000ff;">Rank</SPAN>(<SPAN style="font-style: inherit; font-family: inherit; color: #0000ff;">Sum</SPAN>(<SPAN style="font-style: inherit; font-family: inherit; color: #800000;">Sales</SPAN>)),<SPAN style="font-style: inherit; font-family: inherit; color: #800000;">&lt;PeriodField&gt;,&lt;ShopField&gt;</SPAN>)&lt;=20,Product)</SPAN></P><P><SPAN style="font-size: 10pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">This one ranks and filters top20, but on the measure, it should show measure (Sales), but here its showing me Products name in measure area.&nbsp;&nbsp;&nbsp;&nbsp; <BR /></SPAN></P></BODY></HTML> Wed, 25 Sep 2013 13:08:24 GMT https://community.qlik.com/t5/QlikView/How-to-show-Top20-rows-in-Pivot-table/m-p/475581#M690158 2013-09-25T13:08:24Z Re: How to show Top20 rows in Pivot table? https://community.qlik.com/t5/QlikView/How-to-show-Top20-rows-in-Pivot-table/m-p/475582#M690159 <HTML><HEAD></HEAD><BODY><P>use Sum(Sales) as Expression to your pivot table.</P></BODY></HTML> Wed, 25 Sep 2013 13:15:10 GMT https://community.qlik.com/t5/QlikView/How-to-show-Top20-rows-in-Pivot-table/m-p/475582#M690159 AbhijitBansode 2013-09-25T13:15:10Z