topic Top 5 in pivot in QlikView https://community.qlik.com/t5/QlikView/Top-5-in-pivot/m-p/662863#M241497 <HTML><HEAD></HEAD><BODY><P><BR />Hi all,</P><P></P><P>&nbsp; i want to show top 5 customers in pivot table.how can i get this in pivot</P><P> PFA</P></BODY></HTML> Wed, 27 Aug 2014 13:49:37 GMT 2014-08-27T13:49:37Z Top 5 in pivot https://community.qlik.com/t5/QlikView/Top-5-in-pivot/m-p/662863#M241497 <HTML><HEAD></HEAD><BODY><P><BR />Hi all,</P><P></P><P>&nbsp; i want to show top 5 customers in pivot table.how can i get this in pivot</P><P> PFA</P></BODY></HTML> Wed, 27 Aug 2014 13:49:37 GMT https://community.qlik.com/t5/QlikView/Top-5-in-pivot/m-p/662863#M241497 2014-08-27T13:49:37Z Re: Top 5 in pivot https://community.qlik.com/t5/QlikView/Top-5-in-pivot/m-p/662864#M241498 <HTML><HEAD></HEAD><BODY><P>Create a pivot table</P><P>dimension </P><TABLE border="0" cellpadding="0" cellspacing="0" width="64"><TBODY><TR><TD height="17" width="64">customer </TD></TR></TBODY></TABLE><P></P><P></P><P>Expression</P><P>SUM({&lt;customer = {"=Rank(SUM(cost),4)&lt;=5"}&gt;}cost)</P></BODY></HTML> Wed, 27 Aug 2014 13:53:30 GMT https://community.qlik.com/t5/QlikView/Top-5-in-pivot/m-p/662864#M241498 MK_QSL 2014-08-27T13:53:30Z Re: Top 5 in pivot https://community.qlik.com/t5/QlikView/Top-5-in-pivot/m-p/662865#M241499 <HTML><HEAD></HEAD><BODY><P>as Manish said, it will work...</P><P></P><P>or use Straight table, and use dimension limits tab, select top 5...</P></BODY></HTML> Wed, 27 Aug 2014 13:55:32 GMT https://community.qlik.com/t5/QlikView/Top-5-in-pivot/m-p/662865#M241499 israrkhan 2014-08-27T13:55:32Z