topic Re: Optimizing performance sorting issues in QlikView https://community.qlik.com/t5/QlikView/Optimizing-performance-sorting-issues/m-p/634871#M1299966 <HTML><HEAD></HEAD><BODY><P>Thank you!&nbsp; I ended up using set analysis.</P></BODY></HTML> Tue, 19 Aug 2014 21:35:41 GMT 2014-08-19T21:35:41Z Optimizing performance sorting issues https://community.qlik.com/t5/QlikView/Optimizing-performance-sorting-issues/m-p/634868#M1299962 <HTML><HEAD></HEAD><BODY><P><BR />Hello All,</P><P></P><P>Would you please recommend methods by which I may improve performance that have to do with sorting?&nbsp; 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.&nbsp; Is there a way to limit on a per query basis (i.e. after the dimensions are indicated)?&nbsp; Any suggestions are much appreciated!</P><P></P><P>Thank you,</P><P>Jo</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Optimizing-performance-sorting-issues/m-p/634868#M1299962 2026-01-26T18:19:17Z Re: Optimizing performance sorting issues https://community.qlik.com/t5/QlikView/Optimizing-performance-sorting-issues/m-p/634869#M1299963 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>Post some details about the data model that you use. </P></BODY></HTML> Sat, 31 May 2014 18:25:17 GMT https://community.qlik.com/t5/QlikView/Optimizing-performance-sorting-issues/m-p/634869#M1299963 whiteline 2014-05-31T18:25:17Z Re: Optimizing performance sorting issues https://community.qlik.com/t5/QlikView/Optimizing-performance-sorting-issues/m-p/634870#M1299964 <HTML><HEAD></HEAD><BODY><P>Do you have hundreds of <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">dimensions?</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Could you post some data or more information?<BR /></SPAN></P></BODY></HTML> Sun, 01 Jun 2014 01:37:05 GMT https://community.qlik.com/t5/QlikView/Optimizing-performance-sorting-issues/m-p/634870#M1299964 Clever_Anjos 2014-06-01T01:37:05Z Re: Optimizing performance sorting issues https://community.qlik.com/t5/QlikView/Optimizing-performance-sorting-issues/m-p/634871#M1299966 <HTML><HEAD></HEAD><BODY><P>Thank you!&nbsp; I ended up using set analysis.</P></BODY></HTML> Tue, 19 Aug 2014 21:35:41 GMT https://community.qlik.com/t5/QlikView/Optimizing-performance-sorting-issues/m-p/634871#M1299966 2014-08-19T21:35:41Z