topic Re: Sorting listbox based on another field in QlikView

Sorting listbox based on another field

Fri, 02 Oct 2015 13:16:59 GMT

Hi,

in my example you see left a listbox and on the right there is a tablebox. In this tablebox I have the sorting order for ID based in the obj! How can I do this for the listbox ID?

Thank you

Re: Sorting listbox based on another field

Clever_Anjos — Fri, 02 Oct 2015 13:22:03 GMT

Not so sure about which requirement you have. What do you want to do?

Re: Sorting listbox based on another field

Fri, 02 Oct 2015 13:30:41 GMT

The ID Listbox should have the same sort like the table. Sorting für ID based on Obj...

Re: Sorting listbox based on another field

marcus_sommer — Fri, 02 Oct 2015 13:33:42 GMT

It is the same sorting.

Re: Sorting listbox based on another field

Clever_Anjos — Fri, 02 Oct 2015 13:35:45 GMT

Do you want to do it automatically? If the user changes the sort order of the table, resort the listbox?

Re: Sorting listbox based on another field

Fri, 02 Oct 2015 13:52:27 GMT

In the listbox is...

ID: 1, 2, 3, 4, 5

In the table is...

ID: 1, 3, 2, 4, 5

I want the sorting from the table, which based on Obj in the listbox as well.

Re: Sorting listbox based on another field

jeroen_wagner — Fri, 02 Oct 2015 13:58:43 GMT

You can do the sorting in script.

temp:

LOAD * INLINE [

ID, Obj, Amount

1, A, 10

2, B, 10

3, A, 10

4, B, 10

5, B, 10

];

table:

NoConcatenate LOAD *

Resident temp Order by Obj asc;

Drop Table temp;

Re: Sorting listbox based on another field

marcus_sommer — Fri, 02 Oct 2015 14:01:22 GMT

You need only to change the order of columns within the sorting-tab from the tablebox.

Re: Sorting listbox based on another field

nagaiank — Fri, 02 Oct 2015 14:28:19 GMT

Try changing start order to

match(Obj,'A','B')

instead of Only(Obj)