topic Re: Sort list box by expression in QlikView

Sort list box by expression

edemerdjieva — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have a list box which displays a list of weeks for several years. The list is associated with the "Week" dimension. Week is associated with a "day" dimension in the data model (see attached image).

The values are sorted by:

- state: increasing automatic

- expression: =Min(Num(Date)) decreasing

- numeric value : decreasing

The problem is that when I make a selection in this list box the sort is no longer respected (see attached image). I would like that the sort be always decreasing no matter a selection or not.

Do you have an idea what's wrong ?

Thank you in advance.

Re: Sort list box by expression

tresB — Wed, 12 Dec 2018 10:19:57 GMT

Uncheck 'State' sort order

Re: Sort list box by expression

edemerdjieva — Wed, 12 Dec 2018 10:59:58 GMT

@tresB

It's not working, unfortunately (see image attached).

If I select an old week (and not the last one), there is still the problem with sort.

Re: Sort list box by expression

tresB — Wed, 12 Dec 2018 11:05:03 GMT

Well, since you are using expression for sorting, I guess you have to disregard the selection in that expression, like:

=Min({1}Num(Date))

Re: Sort list box by expression

edemerdjieva — Wed, 12 Dec 2018 13:45:22 GMT

Ok, this one worked. By the way, I had to re-check the state in order to have the selected week(s) in the begining of the coloumn.

I would like to understand why QV ignored previously the sorting ?

Re: Sort list box by expression

tresB — Thu, 13 Dec 2018 07:23:17 GMT

When you select a value, qlik runs your expression on that selected value(s) only; i.e. - the values beyond selections then become out-of-scope. Effectively this makes qlik sort withing the in-scope (selected) value(s) - and rest are not considered in sort. By using {1}, you force qlik to dis-regard the selections and consider all values as in-scope.

Hope this helps.

Re: Sort list box by expression

edemerdjieva — Thu, 13 Dec 2018 09:17:58 GMT

It's clear now :).

Thank you!