topic Top N from pivot table in QlikView https://community.qlik.com/t5/QlikView/Top-N-from-pivot-table/m-p/437020#M163018 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a pivot table with the columns as shown in the attached image. By default my pivot table is grouped by CcyPair column. </P><P>What I would like is to allow users to limit their display on the pivot table dynamically. For eg. I want users to enter value 10 in an input box and then the pivot table must only show the top 10 CcyPairs which has the highest "USD Ntl" total. </P><P>Next, lets assume we already are displaying top 10 ccypairs with highest usd notional as per previous filter. What I would also like to do is allow users to enter a value so that now it displays all CcyPairs which has a total 'Trade Count' greater than 100.</P><P></P><P>Can somebody please show this with an example?</P><P></P><P>PS: Im using QlikView v11</P><P></P><P>Updated:</P><P></P><P>Please note that each ccypair when expanded might have multiple trade id's, counterparties. So this result should not be impacted by the top n selection</P><P></P><P>Cheers</P></BODY></HTML> Tue, 25 Sep 2012 06:18:32 GMT 2012-09-25T06:18:32Z Top N from pivot table https://community.qlik.com/t5/QlikView/Top-N-from-pivot-table/m-p/437020#M163018 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a pivot table with the columns as shown in the attached image. By default my pivot table is grouped by CcyPair column. </P><P>What I would like is to allow users to limit their display on the pivot table dynamically. For eg. I want users to enter value 10 in an input box and then the pivot table must only show the top 10 CcyPairs which has the highest "USD Ntl" total. </P><P>Next, lets assume we already are displaying top 10 ccypairs with highest usd notional as per previous filter. What I would also like to do is allow users to enter a value so that now it displays all CcyPairs which has a total 'Trade Count' greater than 100.</P><P></P><P>Can somebody please show this with an example?</P><P></P><P>PS: Im using QlikView v11</P><P></P><P>Updated:</P><P></P><P>Please note that each ccypair when expanded might have multiple trade id's, counterparties. So this result should not be impacted by the top n selection</P><P></P><P>Cheers</P></BODY></HTML> Tue, 25 Sep 2012 06:18:32 GMT https://community.qlik.com/t5/QlikView/Top-N-from-pivot-table/m-p/437020#M163018 2012-09-25T06:18:32Z