Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Avoid sorting of listbox after selection

Hi,

I have a list box which contains the month names. I sorted it based on Month code using Expression sort. The values come sorted the first time, but after a selection is made, the values are sorted randomly. Is there a way to avoid sorting after a selection is made? Please let me know.

1 Solution

Accepted Solutions
preminqlik
Specialist II
Specialist II

I thinkn u may be busy ,

wite the expression in sort tab and arrange it as ascending,

=only({1}if(Month='Apr',1,

  if(Month='May',2,

  if(Month='Jun',3,

  if(Month='Jul',4,

  if(Month='Aug',5,

  if(Month='Sep',6,

  if(Month='Oct',7,

  if(Month='Nov',8,

  if(Month='Dec',9,

  if(Month='Jan',10,

  if(Month='Feb',11,

  if(Month='Mar',12)))))))))))))

hope this help you...

Regards

Premhas

View solution in original post

7 Replies
preminqlik
Specialist II
Specialist II

can i know expression which is used in sort tab ?

preminqlik
Specialist II
Specialist II

I thinkn u may be busy ,

wite the expression in sort tab and arrange it as ascending,

=only({1}if(Month='Apr',1,

  if(Month='May',2,

  if(Month='Jun',3,

  if(Month='Jul',4,

  if(Month='Aug',5,

  if(Month='Sep',6,

  if(Month='Oct',7,

  if(Month='Nov',8,

  if(Month='Dec',9,

  if(Month='Jan',10,

  if(Month='Feb',11,

  if(Month='Mar',12)))))))))))))

hope this help you...

Regards

Premhas

tresesco
MVP
MVP

Go to general tab, enable 'Show as TreeView'

Or,

In the sort tab, uncheck sort by 'State' .

Not applicable
Author

Hi,

See the attachment.

israrkhan
Specialist II
Specialist II

Hi

as tresesco said,

'Show as TreeView'  sure will work, try it..

CELAMBARASAN
Partner - Champion
Partner - Champion

Uncheck the Sort by State option in Sort tab.

Capture.PNG.png

Not applicable
Author

Guys,

Extremely sorry for not replying. Was out of town. This worked perfectly just that I used only {1} MonthCode, where MonthCode is a column in my month table. Before this I tried un-checking all options (except Expression) but it didn't work. Also, Show as Tree View actually disables Sort by State and seems to be working as well. Thanks everyone who had replied to my question