Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sorting in list boxes

Hi Friends,

I have a list box in my application. It is sorted by using a wild match expression. Now when a selection is done in listbox, I don't want the sorting to be disturbed. that is i dont want the selected items to come on top or come at the end. I want the same sorting structure to remain. Also, if I make a selection, it will be white where as the non selected items will be grey. I want the non selected items to be in the same sorting order as they are in without selection(i.e. On click, the sort order of my list box should not change).  I hope I am clear with my point. Please give in your valuable points to help me solve the same

thanks

joseph

1 Solution

Accepted Solutions
erichshiino
Partner - Master
Partner - Master

Hi,

In the sorting expression you need to make QlikView ignore the selections... otherwise, the unselected will return null for the sorting expression and will go to the bottom.

For example, this sorting expression will do the trick:

=WildMatch( ONLY({1}NAME), '*ABC*')

It sends the names that contain ABC to the top (even if you make other selections).

You can check it on the sample app attached.

Regards,

Erich

View solution in original post

7 Replies
brenner_martina
Partner - Specialist II
Partner - Specialist II

Hi,

at first uncheck in properties and sort the status order, and second, is the box for all your data big enough? If all values are shown in the box, it will not struggle the sort order!

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

    In the sort  you will find the first option as State.

    Deselect that option.

  

    Hope this will solve your problem

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

Hi Friends,

Thank you for your quick replys.

Brenner, I have written that expression for sorting because, I want the list box items to be displayed in the sorting order as per the expression given. For example, I want to show the list box items in the increasing order of sales for the particular list box items. If I remove that sorting option, that will not take me to my solution. Please give me some more help in the same.

Kaushik, I tried doing the changes in the state option. But this was not helping me. When the state option is selected, and if any selection is made in the list box, the selected item moves eithere towards the top or to the botom as per the properties set. But I dont want this to happen. Even if selection is made, it should go up or down.

Please help me with some more pointers.

Regards

Joseph

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

    I have told you to diselect that. means uncheck that option (State)

    This will work

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
erichshiino
Partner - Master
Partner - Master

Hi,

In the sorting expression you need to make QlikView ignore the selections... otherwise, the unselected will return null for the sorting expression and will go to the bottom.

For example, this sorting expression will do the trick:

=WildMatch( ONLY({1}NAME), '*ABC*')

It sends the names that contain ABC to the top (even if you make other selections).

You can check it on the sample app attached.

Regards,

Erich

Not applicable
Author

Thanks a lot Ericho. Your soluiton was near to what I was searching. With your solution as base, I got to my solution...... Thanks to Kaushik and Brenner...... Thanks for giving good help.

Not applicable
Author

Hello everybody once again,

I also want to do the sorting for listboxes where in there is no wildmatch expression but the sorting expression is based on the amount field calculated. ie, i have a list of goods and I want to display the goods in the list box such a way that the item which is sold more must come first in the list and so on. Not only that, even if selections are made, I dont want to change this sorting structure. Please give me some views about this also.

Regards

Joseph