7 Replies Latest reply: May 25, 2011 2:04 AM by Joseph Thoppil RSS

    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´áŐ

        • Sorting in list boxes
          Martina Brenner

          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
            Kaushik Solanki

            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

              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
                  Kaushik Solanki

                  Hi,

                   

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

                   

                      This will work

                   

                  Regards,

                  Kaushik Solanki

                  • Re: Sorting in list boxes
                    Erich Shiino

                    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

                        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

                            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