topic Sorting in current selections object in QlikView

Sorting in current selections object

nigel987 — Tue, 11 Aug 2015 08:08:38 GMT

Hi,

is it possible to sort the selected fields in the current selections object alphabetically?

KR,

Nigel

Re: Sorting in current selections object

marcus_sommer — Tue, 11 Aug 2015 10:13:25 GMT

I don't think so, but you could try it with some alternatives: Current Selection Alternatives.

- Marcus

Re: Sorting in current selections object

nigel987 — Mon, 17 Aug 2015 09:38:14 GMT

I got the following information: The fields in the current selections object are sorted by the order they are loaded into the script (the same order as in Document Settings -> Tables -> Fields section). Hence there is no straightforward way to e.g. order alphabetically.

Re: Sorting in current selections object

marcus_sommer — Mon, 17 Aug 2015 09:59:25 GMT

But it is possible to influence the load-order with a distinct and sorted pre-load from the field-values before you loaded your real tables. QlikView will keep this order as load-order if its loaded the other data and after that you droped this temp-table again. This won't be practically for all fields but for a few important fields its an alternatively.

- Marcus