topic Re: Sort the list box as Red,Yellow,Green! in QlikView https://community.qlik.com/t5/QlikView/Sort-the-list-box-as-Red-Yellow-Green/m-p/331161#M1175635 <HTML><HEAD></HEAD><BODY><P>Try a sort <EM>expression </EM>in sort tab:</P><P></P><P>=match([St Color],'Red','Yellow','Green')</P><P></P><P>with order ascending.</P><P></P><P></P></BODY></HTML> Sun, 01 Apr 2012 18:49:31 GMT swuehl 2012-04-01T18:49:31Z Sort the list box as Red,Yellow,Green! https://community.qlik.com/t5/QlikView/Sort-the-list-box-as-Red-Yellow-Green/m-p/331160#M1175634 <HTML><HEAD></HEAD><BODY><P>Hi Friends</P><P></P><P>I have added a list box which contain three text "<STRONG>Red, Yellow &amp; Green</STRONG>". </P><P></P><P>Currently it is apprering as "<STRONG>Green,Red,Yellow</STRONG>"&nbsp; I want it to appear as "<STRONG>Red,Yellow,Green"</STRONG> (RYG)</P><P></P><P>It works, if you change sort option as Load order &amp; if the excel input order is RYG, but in my case this order will change always.</P><P></P><P>Please help!</P><P></P><P>Enclosed is the file.</P><P></P><P>Thanks in advance for your help!</P><P></P><P>Regards</P><P>Rahul</P></BODY></HTML> Sun, 01 Apr 2012 18:39:12 GMT https://community.qlik.com/t5/QlikView/Sort-the-list-box-as-Red-Yellow-Green/m-p/331160#M1175634 2012-04-01T18:39:12Z Re: Sort the list box as Red,Yellow,Green! https://community.qlik.com/t5/QlikView/Sort-the-list-box-as-Red-Yellow-Green/m-p/331161#M1175635 <HTML><HEAD></HEAD><BODY><P>Try a sort <EM>expression </EM>in sort tab:</P><P></P><P>=match([St Color],'Red','Yellow','Green')</P><P></P><P>with order ascending.</P><P></P><P></P></BODY></HTML> Sun, 01 Apr 2012 18:49:31 GMT https://community.qlik.com/t5/QlikView/Sort-the-list-box-as-Red-Yellow-Green/m-p/331161#M1175635 swuehl 2012-04-01T18:49:31Z Sort the list box as Red,Yellow,Green! https://community.qlik.com/t5/QlikView/Sort-the-list-box-as-Red-Yellow-Green/m-p/331162#M1175636 <HTML><HEAD></HEAD><BODY><P> Thanks Swuehl!</P><P></P><P>It works!!</P></BODY></HTML> Mon, 02 Apr 2012 08:10:13 GMT https://community.qlik.com/t5/QlikView/Sort-the-list-box-as-Red-Yellow-Green/m-p/331162#M1175636 2012-04-02T08:10:13Z