topic Re: Why does MinString sorts different to the sorting by text in listboxes? in Water Cooler https://community.qlik.com/t5/Water-Cooler/Why-does-MinString-sorts-different-to-the-sorting-by-text-in/m-p/623658#M2787 <HTML><HEAD></HEAD><BODY><P>you have to put it in the expression to take effect.</P><P>Cheers,</P><P>E</P></BODY></HTML> Sat, 08 Feb 2014 16:46:59 GMT Anonymous 2014-02-08T16:46:59Z Why does MinString sorts different to the sorting by text in listboxes? https://community.qlik.com/t5/Water-Cooler/Why-does-MinString-sorts-different-to-the-sorting-by-text-in/m-p/623657#M2786 <HTML><HEAD></HEAD><BODY><P>I used MinString($Field) to give me the first field of my selection, but was surprised to get the number three in the ranking of my selection in the example shown below: (all other selections not selecting BLZ gave me the right result !?!)</P><P><IMG alt="MinStringSample.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/52840_MinStringSample.jpg" style="width: 620px; height: 343px;" /></P></BODY></HTML> Sat, 08 Feb 2014 16:33:44 GMT https://community.qlik.com/t5/Water-Cooler/Why-does-MinString-sorts-different-to-the-sorting-by-text-in/m-p/623657#M2786 veidlburkhard 2014-02-08T16:33:44Z Re: Why does MinString sorts different to the sorting by text in listboxes? https://community.qlik.com/t5/Water-Cooler/Why-does-MinString-sorts-different-to-the-sorting-by-text-in/m-p/623658#M2787 <HTML><HEAD></HEAD><BODY><P>you have to put it in the expression to take effect.</P><P>Cheers,</P><P>E</P></BODY></HTML> Sat, 08 Feb 2014 16:46:59 GMT https://community.qlik.com/t5/Water-Cooler/Why-does-MinString-sorts-different-to-the-sorting-by-text-in/m-p/623658#M2787 Anonymous 2014-02-08T16:46:59Z Re: Why does MinString sorts different to the sorting by text in listboxes? https://community.qlik.com/t5/Water-Cooler/Why-does-MinString-sorts-different-to-the-sorting-by-text-in/m-p/623659#M2788 <HTML><HEAD></HEAD><BODY><P>Minstring() seems to handle / sort capital letters in the middle of the string different from the text sort option.</P><P>This just adds to the general confusion of sorting, IMHO, e.g. when sorting numerical parts in a string.</P><P></P><P>A</P><P>=MinString(Capitalize($Field))</P><P></P><P>should get the fist value of your list box values, but that's not a stable solution, I think.</P></BODY></HTML> Sat, 08 Feb 2014 17:05:15 GMT https://community.qlik.com/t5/Water-Cooler/Why-does-MinString-sorts-different-to-the-sorting-by-text-in/m-p/623659#M2788 swuehl 2014-02-08T17:05:15Z Re: Why does MinString sorts different to the sorting by text in listboxes? https://community.qlik.com/t5/Water-Cooler/Why-does-MinString-sorts-different-to-the-sorting-by-text-in/m-p/623660#M2789 <HTML><HEAD></HEAD><BODY><P>Thank you swuehl. This works fine:</P><P><IMG alt="MinString.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/52848_MinString.jpg" style="width: 620px; height: 341px;" /></P></BODY></HTML> Sat, 08 Feb 2014 17:47:54 GMT https://community.qlik.com/t5/Water-Cooler/Why-does-MinString-sorts-different-to-the-sorting-by-text-in/m-p/623660#M2789 veidlburkhard 2014-02-08T17:47:54Z