Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2015-12-10 07:09 AM

List box behavior???

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

Preview file
96 KB
1,251 Views
0 Likes
1 Solution

Accepted Solutions
Not applicable
‎2015-12-16 05:00 AM
Author

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

View solution in original post

Preview file
257 KB
1,089 Views
0 Likes
12 Replies
Anonymous
Not applicable
‎2015-12-10 07:15 AM
Author

sample QVW?

850 Views
0 Likes
Not applicable
‎2015-12-10 07:16 AM
Author

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

850 Views
0 Likes
Not applicable
‎2015-12-10 07:17 AM
Author

Hi siva,

just unchecked the expression in sort tab

Untitled.png

850 Views
0 Likes
Anonymous
Not applicable
‎2015-12-10 07:18 AM
Author

may this help you?

Preview file
157 KB
850 Views
0 Likes
roger_stone
Creator III
Creator III
‎2015-12-10 07:18 AM

Untick 'State' in the Sort tab.

850 Views
0 Likes
tamilarasu
Champion
Champion
‎2015-12-10 07:21 AM

Hi Siva,


Untick both the sort by options in sort tab.

850 Views
0 Likes
Not applicable
‎2015-12-10 08:00 AM
Author

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

850 Views
0 Likes
Not applicable
‎2015-12-10 08:03 AM
Author

In response to

Can you try the following:

  • Uncheck 'State'
  • Check 'Expression'
  • enter MOMonth in the Expression field (as you already had it)
850 Views
0 Likes
Not applicable
‎2015-12-10 08:28 AM
Author

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

850 Views
0 Likes