topic Sorting in alternate states (List box) in QlikView

Sorting in alternate states (List box)

Sun, 27 Jul 2014 11:25:59 GMT

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.

Re: Sorting in alternate states (List box)

Sun, 27 Jul 2014 12:54:00 GMT

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.

Re: Sorting in alternate states (List box)

md_qlikview — Sun, 27 Jul 2014 13:05:46 GMT

Try out by Checking the Checkbox Load Order with Original.

Re: Sorting in alternate states (List box)

dharmarasu — Mon, 28 Jul 2014 05:13:57 GMT

Hi ,

See this...

Hope this helps..

Dharma

Re: Sorting in alternate states (List box)

amit_saini — Mon, 28 Jul 2014 05:25:47 GMT

Salman ,

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

Thanks,

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

Mon, 28 Jul 2014 10:37:53 GMT

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