topic limit the number of results for a given dimension in a pivot table in QlikView https://community.qlik.com/t5/QlikView/limit-the-number-of-results-for-a-given-dimension-in-a-pivot/m-p/150357#M28405 <HTML><HEAD></HEAD><BODY><P>How do you want to identify top 3 products for any customer? You can write a set expression to get top product on the basis of some metrics e.g. top3 products w.r.t sales,etc.</P></BODY></HTML> Mon, 27 Jul 2009 18:03:15 GMT 2009-07-27T18:03:15Z limit the number of results for a given dimension in a pivot table https://community.qlik.com/t5/QlikView/limit-the-number-of-results-for-a-given-dimension-in-a-pivot/m-p/150355#M28403 <HTML><HEAD></HEAD><BODY><P>Does anyone know of a way to limit the number of results displayed for an expresion for a dimension in a pivot table?</P><P></P><P>I have a table that contains sales which has a date dimension across the top and customers as dimension 1 and items as dimensions 2 down the side. I would like to see all customers but only the top 3 items for each customer. Is this possible without doing prior analysis to identify those customer/item combinations and then loading those records as a dimension?</P><P>Also on the wish list is to be able to display the total sales for each customer below their top 3 items but I suspect that this would be contrary to the logic of a pivot table and would need to be tackled through a straight table. Any thoughts?</P><P></P><P>As always, all help is much appreciated.</P></BODY></HTML> Mon, 27 Jul 2009 17:40:44 GMT https://community.qlik.com/t5/QlikView/limit-the-number-of-results-for-a-given-dimension-in-a-pivot/m-p/150355#M28403 2009-07-27T17:40:44Z limit the number of results for a given dimension in a pivot table https://community.qlik.com/t5/QlikView/limit-the-number-of-results-for-a-given-dimension-in-a-pivot/m-p/150356#M28404 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>you need a dynamic dimension like:</P><P>=Aggr(If(Rank(Sum(Amount)) &lt;=3, Company, 'Others'), Company)</P><P>So you solve the first part of your questions.</P><P>Rainer</P></BODY></HTML> Mon, 27 Jul 2009 17:50:26 GMT https://community.qlik.com/t5/QlikView/limit-the-number-of-results-for-a-given-dimension-in-a-pivot/m-p/150356#M28404 2009-07-27T17:50:26Z limit the number of results for a given dimension in a pivot table https://community.qlik.com/t5/QlikView/limit-the-number-of-results-for-a-given-dimension-in-a-pivot/m-p/150357#M28405 <HTML><HEAD></HEAD><BODY><P>How do you want to identify top 3 products for any customer? You can write a set expression to get top product on the basis of some metrics e.g. top3 products w.r.t sales,etc.</P></BODY></HTML> Mon, 27 Jul 2009 18:03:15 GMT https://community.qlik.com/t5/QlikView/limit-the-number-of-results-for-a-given-dimension-in-a-pivot/m-p/150357#M28405 2009-07-27T18:03:15Z limit the number of results for a given dimension in a pivot table https://community.qlik.com/t5/QlikView/limit-the-number-of-results-for-a-given-dimension-in-a-pivot/m-p/150358#M28406 <HTML><HEAD></HEAD><BODY><P>Good question. I hadnt thought up to now but I guess I will build a set based on last month or last quarter.</P><P>Regarding the aggr function above, how might that look in terms of my customer and item dimensions? I have been having a play around with it and have hit some good pointers but also some unexpected results.</P><P>edit:</P><P>This may be the expression I was looking for (apart from the set part)</P><P>=aggr(if(rank(sum(sales))&lt;=3, Item,'Others'),Customer,Item)</P><P></P><P></P></BODY></HTML> Mon, 27 Jul 2009 19:15:17 GMT https://community.qlik.com/t5/QlikView/limit-the-number-of-results-for-a-given-dimension-in-a-pivot/m-p/150358#M28406 2009-07-27T19:15:17Z