topic Re: Sort / filter field in QlikView

Sort / filter field

Mon, 26 Jan 2026 18:19:17 GMT

Hello,

Would you please let me know how I would handle filtering a field (for example a client number) so that I can display the top "N" of it in a chart by different dimensions (for example, by product or region or revenue size)? I know that I can limit the display on the dimension limits page by using the "Restrict which values are displayed..." but it still has to sort through all the values in order to limit by order so is there a way to limit the amount it sorts through first, please?

Thank you

Re: Sort / filter field

Gysbert_Wassenaar — Thu, 12 Jun 2014 07:21:16 GMT

No, there isn't. If you want a Top N, then the values will be sorted first. If you want to restrict values by other criteria first, for example the values for only one region, then make the appropriate selections first.

Re: Sort / filter field

rbecher — Thu, 12 Jun 2014 07:34:35 GMT

You could probably use a dynamic set analysis with a variable to filter different dimensions in this way:

=sum({<$(vDimension)={'$(vDimValue)'}>} MeasureField)

Re: Sort / filter field

Tue, 19 Aug 2014 21:33:59 GMT

Thank you! I did end up using set analysis that looked something like this:

Sum({<Client={"=Rank(Sum($(Sales)),4)<=$(vTopN)"}>} $(Sales))