topic Re: List box behavior??? in QlikView

List box behavior???

Thu, 10 Dec 2015 12:09:52 GMT

I would like to change the behaviour of Listbox, when i select the field values. i dont want the field values to be moved when the selections were made, it should be intact. The screen shots were provided in the attachment.

Please suggest

Regards

Siva

Re: List box behavior???

Anonymous — Thu, 10 Dec 2015 12:15:37 GMT

sample QVW?

Re: List box behavior???

Thu, 10 Dec 2015 12:16:38 GMT

Hi Siva

The answer is on your third screenshot - the 'Sort' tab.

If 'State' is checked, then the selected items will sort to the Top (or Left in your example). Uncheck 'State' and the list box will sort by MOMonth only.

Thanks

Bob

Re: List box behavior???

Thu, 10 Dec 2015 12:17:22 GMT

Hi siva,

just unchecked the expression in sort tab

Re: List box behavior???

Anonymous — Thu, 10 Dec 2015 12:18:26 GMT

may this help you?

Re: List box behavior???

roger_stone — Thu, 10 Dec 2015 12:18:37 GMT

Untick 'State' in the Sort tab.

Re: List box behavior???

tamilarasu — Thu, 10 Dec 2015 12:21:58 GMT

Hi Siva,

Untick both the sort by options in sort tab.

Re: List box behavior???

Thu, 10 Dec 2015 13:00:13 GMT

sorry guys...its not working, as expected...

Re: List box behavior???

Thu, 10 Dec 2015 13:03:41 GMT

Can you try the following:

Uncheck 'State'
Check 'Expression'
enter MOMonth in the Expression field (as you already had it)

Re: List box behavior???

Thu, 10 Dec 2015 13:28:01 GMT

i would like to attach one document to this original attached document.. but couldn't find any button to attach the updated document... Thanks for all your help.. Regards Siva

Re: List box behavior???

avinashelite — Thu, 10 Dec 2015 13:30:47 GMT

In the sort tab uncheck the sort on STATE , that will serve your requirement

Re: List box behavior???

avinashelite — Thu, 10 Dec 2015 13:32:36 GMT

if you want to upload a app then > While replying at the right top you will have the option

Use advanced editor >click on that then in the bottom left you will get the option to attach the file .

Hope this helps you

Re: List box behavior???

Wed, 16 Dec 2015 10:00:36 GMT

Thanks to all of you for your participation and suggestions...

i have tried your suggestions, but no luck. I slightly changed the data model by linking another table MonthlyOrder1 with Monthname (Month) and MonthOrder according to the calender. and then it worked correctly. The problem with previous data model is MonthlyORDER table which is ordered by YMOrder(ie>YearMonth combination).And if i use Month and MoORDER fields from this MonthlyORDER, its not getting order by MoORDER but its getting orderby YMOrder, eventhough i used MoORDER is the sorted Expression property.

if I didn't order by YMOrder column in the script, all you suggestions might have worked. All your suggestion are correct, but was not suited for my data model (as i had orderby different column). Hope this makes sense....

Please check the attachment for more details..

Hope this may help you.

Thanks a lot....

Regards

Siva