topic Avoid sorting of listbox after selection in QlikView

Avoid sorting of listbox after selection

Sat, 19 Oct 2013 03:55:36 GMT

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.

Re: Avoid sorting of listbox after selection

preminqlik — Sat, 19 Oct 2013 04:33:59 GMT

can i know expression which is used in sort tab ?

Re: Avoid sorting of listbox after selection

preminqlik — Sat, 19 Oct 2013 05:20:42 GMT

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

Re: Avoid sorting of listbox after selection

tresB — Sat, 19 Oct 2013 08:09:26 GMT

Go to general tab, enable 'Show as TreeView'

Or,

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

Re: Avoid sorting of listbox after selection

Sat, 19 Oct 2013 08:48:52 GMT

Hi,

See the attachment.

Re: Avoid sorting of listbox after selection

israrkhan — Sat, 19 Oct 2013 10:05:54 GMT

as tresesco said,

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

Re: Avoid sorting of listbox after selection

CELAMBARASAN — Sat, 19 Oct 2013 16:40:49 GMT

Uncheck the Sort by State option in Sort tab.

Re: Re: Avoid sorting of listbox after selection

Sat, 19 Oct 2013 19:47:27 GMT

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