topic Re: Use DUAL-Function to define the sort-order in QlikView https://community.qlik.com/t5/QlikView/Use-DUAL-Function-to-define-the-sort-order/m-p/392625#M146453 <HTML><HEAD></HEAD><BODY><P>Thank you Stefan. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> It works.</P></BODY></HTML> Fri, 01 Feb 2013 13:45:55 GMT 2013-02-01T13:45:55Z Use DUAL-Function to define the sort-order https://community.qlik.com/t5/QlikView/Use-DUAL-Function-to-define-the-sort-order/m-p/392623#M146451 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;"></SPAN></P><P>Hello Community,</P><P></P><P>can someone please help me to use the DUAL-Function to sort the columns Col1 and Col2 in the script?<BR /><BR /><BR /><BR />I want this solution:<BR /><BR /><BR /><BR />A &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;big&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;x<BR /><BR />A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;small&nbsp;&nbsp; a<BR /><BR />A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;big&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;y<BR /><BR />A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;small&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;z<BR /><BR />B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;big&nbsp;&nbsp;&nbsp;&nbsp; c<BR /><BR />B&nbsp;&nbsp; small&nbsp;&nbsp; b<BR /><BR />C&nbsp;&nbsp; big&nbsp;&nbsp;&nbsp;&nbsp; d<BR /><BR /><BR /><BR /><BR /><BR />Important is the sort-order at Col1 and Col2. So after "big" should come "small".<BR /><BR />the qv-file is attached.</P><P></P><P>Thanks! best regards, aylin<BR /><BR /><BR /><BR /> </P><P></P></BODY></HTML> Fri, 01 Feb 2013 09:07:12 GMT https://community.qlik.com/t5/QlikView/Use-DUAL-Function-to-define-the-sort-order/m-p/392623#M146451 2013-02-01T09:07:12Z Re: Use DUAL-Function to define the sort-order https://community.qlik.com/t5/QlikView/Use-DUAL-Function-to-define-the-sort-order/m-p/392624#M146452 <HTML><HEAD></HEAD><BODY><P>Maybe like attached?</P><P></P><P>Stefan</P></BODY></HTML> Fri, 01 Feb 2013 09:53:43 GMT https://community.qlik.com/t5/QlikView/Use-DUAL-Function-to-define-the-sort-order/m-p/392624#M146452 swuehl 2013-02-01T09:53:43Z Re: Use DUAL-Function to define the sort-order https://community.qlik.com/t5/QlikView/Use-DUAL-Function-to-define-the-sort-order/m-p/392625#M146453 <HTML><HEAD></HEAD><BODY><P>Thank you Stefan. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> It works.</P></BODY></HTML> Fri, 01 Feb 2013 13:45:55 GMT https://community.qlik.com/t5/QlikView/Use-DUAL-Function-to-define-the-sort-order/m-p/392625#M146453 2013-02-01T13:45:55Z