Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Sorting listbox based on another field

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

1 Solution

Accepted Solutions
nagaiank
Valued Contributor III

Re: Sorting listbox based on another field

Try changing start order to

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

instead of Only(Obj)

8 Replies
Employee
Employee

Re: Sorting listbox based on another field

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

Not applicable

Re: Sorting listbox based on another field

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

It is the same sorting.

Employee
Employee

Re: Sorting listbox based on another field

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

Not applicable

Re: Sorting listbox based on another field

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.

jeroen_wagner
Contributor

Re: Sorting listbox based on another field

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

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

nagaiank
Valued Contributor III

Re: Sorting listbox based on another field

Try changing start order to

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

instead of Only(Obj)

Community Browser