topic Re: How to Show top 10 Minimum Values in Pivot table in QlikView https://community.qlik.com/t5/QlikView/How-to-Show-top-10-Minimum-Values-in-Pivot-table/m-p/917478#M983091 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000080; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">If(Aggr(Rank(-Sum(Cost)) &lt;= 10,your_required_Dimension),<SPAN style="color: #000080; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">your_required_Dimension</SPAN>)</SPAN></P></BODY></HTML> Mon, 10 Aug 2015 12:02:04 GMT avinashelite 2015-08-10T12:02:04Z How to Show top 10 Minimum Values in Pivot table https://community.qlik.com/t5/QlikView/How-to-Show-top-10-Minimum-Values-in-Pivot-table/m-p/917477#M983090 <HTML><HEAD></HEAD><BODY><P>Hi Friends,</P><P></P><P>Attached is the Data I have.</P><P>I am Using Fields Description, Item &amp; Inventory as&nbsp; Dimensions and Rest of the Fields Cost, CurrentCost, Qty &amp; CurrentQty&nbsp; using In Expressions</P><P>Actually Field (<STRONG>Cost</STRONG>) have <STRONG style=": ; color: #575757; text-decoration: underline;">Negative Values</STRONG><SPAN style="text-decoration: underline;"><SPAN style="color: #575757; text-decoration: underline;">.</SPAN></SPAN></P><P></P><P>My Question is I want to show Field(Cost) in <STRONG style=": ; font-size: 12pt; text-decoration: underline;">lowest to highest</STRONG> that is <STRONG style=": ; font-size: 12pt; text-decoration: underline;">top 10 negative values</STRONG><SPAN style="font-size: 12pt;">&nbsp; </SPAN><SPAN style="font-size: 12pt;">in </SPAN><STRONG><SPAN style="font-size: 12pt;"> </SPAN><SPAN style="font-size: 12pt; text-decoration: underline;">PIVOT TABLE</SPAN></STRONG></P><P></P><P>How Can It will be Resolve. Can any one help on this</P><P></P><P>Thank you,</P><P>Satya Paleti.</P></BODY></HTML> Mon, 10 Aug 2015 11:43:00 GMT https://community.qlik.com/t5/QlikView/How-to-Show-top-10-Minimum-Values-in-Pivot-table/m-p/917477#M983090 SatyaPaleti 2015-08-10T11:43:00Z Re: How to Show top 10 Minimum Values in Pivot table https://community.qlik.com/t5/QlikView/How-to-Show-top-10-Minimum-Values-in-Pivot-table/m-p/917478#M983091 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000080; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">If(Aggr(Rank(-Sum(Cost)) &lt;= 10,your_required_Dimension),<SPAN style="color: #000080; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">your_required_Dimension</SPAN>)</SPAN></P></BODY></HTML> Mon, 10 Aug 2015 12:02:04 GMT https://community.qlik.com/t5/QlikView/How-to-Show-top-10-Minimum-Values-in-Pivot-table/m-p/917478#M983091 avinashelite 2015-08-10T12:02:04Z Re: How to Show top 10 Minimum Values in Pivot table https://community.qlik.com/t5/QlikView/How-to-Show-top-10-Minimum-Values-in-Pivot-table/m-p/917479#M983092 <HTML><HEAD></HEAD><BODY><P>Satya,</P><P></P><P>PFA</P></BODY></HTML> Mon, 10 Aug 2015 12:06:09 GMT https://community.qlik.com/t5/QlikView/How-to-Show-top-10-Minimum-Values-in-Pivot-table/m-p/917479#M983092 qlikmsg4u 2015-08-10T12:06:09Z