topic Re: Sorting list box in QlikView

Sorting list box

Thu, 21 Nov 2013 14:43:16 GMT

I have sorted a list box by three criteria,

firstly by the state (As auto ascending)
secondly by an expression
thirdly by text

My custom expression is if(sum(round(quantity))>0,1,2) ie so it sums up the activity and if is greater than one sorts first

This all works fine, however when i make other selections in other list boxes, and my options in the list box described above reduce, the grey options ie the ones unavailable for selection are not filtered in the correct order as mentioned above.

So when no selections are made the list box is sorted correcty as per above, when selections are made, the ones available are sent to the top as they should, but the greyed out unavailable selections are sorted as per the default setting,

is it possible for these options to be sorted as well as per my criteria above?

Thanks

Jon

Re: Sorting list box

Nicole-Smith — Thu, 21 Nov 2013 19:55:23 GMT

Try changing the custom expression to: if(sum({1}round(quantity))>0,1,2)

This should ignore the other selections that you're making.

Re: Sorting list box

Mon, 25 Nov 2013 12:24:29 GMT

Thanks a lot for your answer, this works fine for me.

However I also have a different custom sort as per below which sorts the customers based on a standard rule for prefixes which we use.

I am currently experiencing the same issue as above, how can incorporate the modification into the formula below which isnt a sum formula

if(right([Cust ID],3) <> '_L5',1,2)

Re: Sorting list box

Mon, 25 Nov 2013 12:40:37 GMT

Hi,

Use the sort expression you are using, in the script rather.

Let's say the column is SortOrder.

Then in the sort option of list box, use the expression only({1}SortOrder). This should work.

Re: Sorting list box

Nicole-Smith — Mon, 25 Nov 2013 13:34:09 GMT

Try:

if(right(only({1}[Cust ID]),3) <> '_L5',1,2)