Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Sorting in alternate states (List box)

Hi All,

I am struggling with a listbox and am trying to sort the two alternate states of it. I have attached an example here that shows my situation. The listbox is sorted based on expression, but when I select something, the other (unselected) state doesn't remain in same order but it seems that it is sorted randomly. I want it to remain in the same order as of sort expression. Please advise.

1 Solution

Accepted Solutions
Not applicable

Re: Sorting in alternate states (List box)

Hi Salman,

When you select an item from the listbox, the Procedure_Code for the rest of the items becomes null.

To overcome this, try replacing the sort expression with the below:

only({1} Procedure_Code)

Hope that's what you were looking for.

5 Replies
Not applicable

Re: Sorting in alternate states (List box)

Hi Salman,

When you select an item from the listbox, the Procedure_Code for the rest of the items becomes null.

To overcome this, try replacing the sort expression with the below:

only({1} Procedure_Code)

Hope that's what you were looking for.

md_qlikview
Contributor II

Re: Sorting in alternate states (List box)

Try out by Checking the Checkbox Load Order with Original.

dharmarasu
Contributor

Re: Sorting in alternate states (List box)

Hi ,

See this...

Hope this helps..

Dharma

amit_saini
Honored Contributor III

Re: Sorting in alternate states (List box)

Salman ,

Go to list box properties->under Sort ->check State as Ascending.

Thanks,

AS

Not applicable

Re: Re: Sorting in alternate states (List box)

Thank you JP, the suggestion you made was a perfect solution for me.

Community Browser