topic Sorting in list boxes in QlikView

Sorting in list boxes

Tue, 24 May 2011 12:12:46 GMT

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

Sorting in list boxes

brenner_martina — Tue, 24 May 2011 12:16:24 GMT

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!

Sorting in list boxes

kaushiknsolanki — Tue, 24 May 2011 12:18:10 GMT

Hi,

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

Deselect that option.

Hope this will solve your problem

Regards,

Kaushik Solanki

Sorting in list boxes

Tue, 24 May 2011 12:28:42 GMT

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

Sorting in list boxes

kaushiknsolanki — Tue, 24 May 2011 12:57:35 GMT

Hi,

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

This will work

Regards,

Kaushik Solanki

Re: Sorting in list boxes

erichshiino — Tue, 24 May 2011 13:08:21 GMT

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

Re: Sorting in list boxes

Tue, 24 May 2011 14:01:20 GMT

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.

Sorting in list boxes

Wed, 25 May 2011 06:04:44 GMT

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