topic getfieldselections() & Current Selections sort alphabetically in QlikView

getfieldselections() & Current Selections sort alphabetically

Wed, 26 Nov 2014 14:20:26 GMT

Hi All,

I have a textbox that is built up using the getfieldselections() function in a text box. The problem is that the selections are not displayed in alphabetical order like the list box used to make the selection. Also, if I view the selection in Current Selections box, the sort order is incorrect also. In both instances I need it to be alphabetical.

Is there a workaround somewhere for this?

For example if you select A, B, C, D I want the result of the getfieldselections() to show A, B, C, D . At the moment, it is A, C, B, D (unknown order).

Cheers,

GPC

Re: getfieldselections() & Current Selections sort alphabetically

marcus_sommer — Wed, 26 Nov 2014 14:35:43 GMT

For getfieldselections() isn't a sort-option available but you could try it with concat(). But first have a look to the approaches here: Current Selection Alternatives.

- Marcus

Re: getfieldselections() & Current Selections sort alphabetically

Anonymous — Wed, 26 Nov 2014 14:36:24 GMT

Hi Gareth,

The fields in the current selections object are sorted by load order and there is no option to change that property in the object's properties dialog . The only way to change sort it differently in the object is to change the order in which the fields are loaded in the script.

Regards.

Neetha