Sorting in alternate states (List box)

[#1]

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.

[#2 · Accepted solution]

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]

Try out by Checking the Checkbox Load Order with Original.

[dharmarasu]

Hi ,

See this...

Hope this helps..

Dharma

[amit_saini]

Salman ,

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

Thanks,

AS

[#6]

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