3 Replies Latest reply: Aug 19, 2014 5:35 PM by Jo Fake RSS

    Optimizing performance sorting issues

    Jo Fake


      Hello All,

       

      Would you please recommend methods by which I may improve performance that have to do with sorting?  My problem is that I have many rows (for example, one customer/product is one row) and many dimensions (hundreds) and I need to display the top "x" of these products on a per row level basis so pre-aggregating and an additional table are not options due to the complexity. QlikView needs to sort the entire database in order to present the top x.  Is there a way to limit on a per query basis (i.e. after the dimensions are indicated)?  Any suggestions are much appreciated!

       

      Thank you,

      Jo