topic Help needed for Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Help-needed-for-Pivot-Table/m-p/430707#M160608 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>In my application in one input box user is entering the No. of top recoreds he want see..Lets say top 5..</P><P></P><P>I want to dispay only top 5 records in the pivot table.</P><P>I am using QlikView 10.</P><P></P><P>So how to display conditional records in pivot table??</P></BODY></HTML> Tue, 12 Feb 2013 21:45:22 GMT 2013-02-12T21:45:22Z Help needed for Pivot Table https://community.qlik.com/t5/QlikView/Help-needed-for-Pivot-Table/m-p/430707#M160608 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>In my application in one input box user is entering the No. of top recoreds he want see..Lets say top 5..</P><P></P><P>I want to dispay only top 5 records in the pivot table.</P><P>I am using QlikView 10.</P><P></P><P>So how to display conditional records in pivot table??</P></BODY></HTML> Tue, 12 Feb 2013 21:45:22 GMT https://community.qlik.com/t5/QlikView/Help-needed-for-Pivot-Table/m-p/430707#M160608 2013-02-12T21:45:22Z Re: Help needed for Pivot Table https://community.qlik.com/t5/QlikView/Help-needed-for-Pivot-Table/m-p/430708#M160609 <HTML><HEAD></HEAD><BODY><P>use calcualted dimension like this</P><P></P><P>If(Rank(aggrSum( Sales],Field))&nbsp; &lt;= 'variable', Field)</P><P>)</P></BODY></HTML> Tue, 12 Feb 2013 22:00:28 GMT https://community.qlik.com/t5/QlikView/Help-needed-for-Pivot-Table/m-p/430708#M160609 Anonymous 2013-02-12T22:00:28Z