topic Re: Order in List Box in QlikView https://community.qlik.com/t5/QlikView/Order-in-List-Box/m-p/489500#M182930 <HTML><HEAD></HEAD><BODY><P>Try enabling 'Tree View' . General tab-&gt; Show as TreeView</P></BODY></HTML> Fri, 27 Sep 2013 15:37:00 GMT tresB 2013-09-27T15:37:00Z Order in List Box https://community.qlik.com/t5/QlikView/Order-in-List-Box/m-p/489499#M182929 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I have a table with the following values:</P><P></P><P><SPAN style="font-family: courier new,courier; text-decoration: underline;">Product Type Code | Product Type</SPAN></P><P><SPAN style="font-family: courier new,courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100 | Vegetables</SPAN></P><P><SPAN style="font-family: courier new,courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200 | Fruits</SPAN></P><P><SPAN style="font-family: courier new,courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300 | Beverages</SPAN></P><P></P><P>In a list box displays the following:</P><P></P><P><SPAN style="font-family: courier new,courier; text-decoration: underline;">Product Type</SPAN></P><P><SPAN style="font-family: courier new,courier;">Vegetables</SPAN></P><P><SPAN style="font-family: courier new,courier;">Fruits</SPAN></P><P><SPAN style="font-family: courier new,courier;">Beverages</SPAN></P><P><SPAN style="font-family: courier new,courier;"> </SPAN></P><P>In the properties of the object, on the Order tab I have configured the following:</P><P></P><P><X> Expression [Ascending]</X></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-family: courier new,courier;">[Product Type code]</SPAN></P><P></P><P>But when I select "Fruit", this value is until the end of the list being:</P><P></P><P><SPAN style="font-family: courier new,courier; text-decoration: underline;">Product Type</SPAN></P><P><SPAN style="font-family: courier new,courier;">Beverages</SPAN></P><P><SPAN style="font-family: courier new,courier;">Vegetables</SPAN></P><P><SPAN style="font-family: courier new,courier;">Fruits</SPAN></P><P><BR />How I can do to remain exactly as I ordered it originally?</P></BODY></HTML> Fri, 27 Sep 2013 15:34:25 GMT https://community.qlik.com/t5/QlikView/Order-in-List-Box/m-p/489499#M182929 coddra_6 2013-09-27T15:34:25Z Re: Order in List Box https://community.qlik.com/t5/QlikView/Order-in-List-Box/m-p/489500#M182930 <HTML><HEAD></HEAD><BODY><P>Try enabling 'Tree View' . General tab-&gt; Show as TreeView</P></BODY></HTML> Fri, 27 Sep 2013 15:37:00 GMT https://community.qlik.com/t5/QlikView/Order-in-List-Box/m-p/489500#M182930 tresB 2013-09-27T15:37:00Z