https://community.qlik.com/t5/QlikView/How-to-sort-a-listbox-with-dual-values-alphabetical/m-p/1564633#M508227 <P>Hi Vegar<BR />&nbsp;try using expression in the list box<BR />i.e. text(Month)<span class="lia-inline-image-display-wrapper lia-image-align-right" image-alt="Capture.PNG" style="width: 364px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/9394iF71EEEBD434DFF79/image-size/large?v=v2&amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P><P>&nbsp;</P> Wed, 03 Apr 2019 13:52:10 GMT dplr-rn 2019-04-03T13:52:10Z https://community.qlik.com/t5/QlikView/How-to-sort-a-listbox-with-dual-values-alphabetical/m-p/1564610#M508226 <P>I'm trying to sort my listbox values alphabetical by text value, but I'm not able to? (I'm sorry for the odd language in the gif animation below, but I think you get the point.)</P><P>Can you guys confirm this behaviour on your QlikView desktops? Do you have a workaround without changing the dual into a text in the data load?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="How 2 sort a dual.gif" style="width: 889px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/9389i2DD2E835CA74B75E/image-size/large?v=v2&amp;px=999" role="button" title="How 2 sort a dual.gif" alt="How 2 sort a dual.gif" /></span></P><P>My desired output is&nbsp;</P><UL><LI>aug.</LI><LI>dec.</LI><LI>feb.</LI><LI>jan.</LI><LI>juli</LI><LI>juni</LI><LI>maj</LI><LI>mars</LI><LI>nov.</LI><LI>okt</LI><LI>sep.</LI></UL><P>&nbsp;</P><P>Im working in the November 2018 release.</P> Sat, 16 Nov 2024 03:57:51 GMT https://community.qlik.com/t5/QlikView/How-to-sort-a-listbox-with-dual-values-alphabetical/m-p/1564610#M508226 Vegar 2024-11-16T03:57:51Z https://community.qlik.com/t5/QlikView/How-to-sort-a-listbox-with-dual-values-alphabetical/m-p/1564633#M508227 <P>Hi Vegar<BR />&nbsp;try using expression in the list box<BR />i.e. text(Month)<span class="lia-inline-image-display-wrapper lia-image-align-right" image-alt="Capture.PNG" style="width: 364px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/9394iF71EEEBD434DFF79/image-size/large?v=v2&amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P><P>&nbsp;</P> Wed, 03 Apr 2019 13:52:10 GMT https://community.qlik.com/t5/QlikView/How-to-sort-a-listbox-with-dual-values-alphabetical/m-p/1564633#M508227 dplr-rn 2019-04-03T13:52:10Z https://community.qlik.com/t5/QlikView/How-to-sort-a-listbox-with-dual-values-alphabetical/m-p/1564662#M508228 Your solution works like a charm.<BR />I was afraid to get odd expression-like selections in my current selection box, but it behaves normal. Wed, 03 Apr 2019 14:28:22 GMT https://community.qlik.com/t5/QlikView/How-to-sort-a-listbox-with-dual-values-alphabetical/m-p/1564662#M508228 Vegar 2019-04-03T14:28:22Z