topic Order by in script in QlikView https://community.qlik.com/t5/QlikView/Order-by-in-script/m-p/366426#M704025 <HTML><HEAD></HEAD><BODY><P>I am trying to sort the data below.</P><P>The sort order should be 1, 2 and 3.</P><P></P><P>This is what a have:</P><P></P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp; </P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" height="155" style="height: 157px; width: 342px;"><TBODY><TR><TD class="xl63" height="17" width="93">145</TD><TD class="xl63" style="border-left-style: none;" width="62">2007-10-15</TD><TD class="xl63" style="border-left-style: none;" width="59">4612A</TD></TR><TR><TD class="xl63" height="17" style="border-top-style: none;">145</TD><TD class="xl63" style="border-top-style: none; border-left-style: none;">2008-05-05</TD><TD align="right" class="xl64" style="border-top-style: none; border-left-style: none;">10610001</TD></TR><TR><TD class="xl63" height="17" style="border-top-style: none;">145</TD><TD class="xl63" style="border-top-style: none; border-left-style: none;">2008-05-05</TD><TD class="xl63" style="border-top-style: none; border-left-style: none;">4612A</TD></TR><TR><TD class="xl63" height="17" style="border-top-style: none;">145</TD><TD class="xl63" style="border-top-style: none; border-left-style: none;">2008-10-16</TD><TD align="right" class="xl64" style="border-top-style: none; border-left-style: none;">611015</TD></TR><TR><TD class="xl63" height="17" style="border-top-style: none;">145</TD><TD class="xl63" style="border-top-style: none; border-left-style: none;">2009-03-20</TD><TD align="right" class="xl64" style="border-top-style: none; border-left-style: none;">10610001</TD></TR></TBODY></TABLE><P></P><P>This is what I want to have:</P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" height="184" style="height: 186px; width: 341px;"><TBODY><TR><TD class="xl63" height="17" width="93">145</TD><TD class="xl63" style="border-left-style: none;" width="62">2007-10-15</TD><TD class="xl63" style="border-left-style: none;" width="59">4612A</TD></TR><TR><TD class="xl63" height="17" style="border-top-style: none;">145</TD><TD class="xl63" style="border-top-style: none; border-left-style: none;">2008-05-05</TD><TD align="right" class="xl64" style="border-top-style: none; border-left-style: none;">4612A</TD></TR><TR><TD class="xl63" height="17" style="border-top-style: none;">145</TD><TD class="xl63" style="border-top-style: none; border-left-style: none;">2008-05-05</TD><TD class="xl63" style="border-top-style: none; border-left-style: none;"><SPAN style="text-align: -webkit-right;">10610001</SPAN></TD></TR><TR><TD class="xl63" height="17" style="border-top-style: none;">145</TD><TD class="xl63" style="border-top-style: none; border-left-style: none;">2008-10-16</TD><TD align="right" class="xl64" style="border-top-style: none; border-left-style: none;">611015</TD></TR><TR><TD class="xl63" height="17" style="border-top-style: none;">145</TD><TD class="xl63" style="border-top-style: none; border-left-style: none;">2009-03-20</TD><TD align="right" class="xl64" style="border-top-style: none; border-left-style: none;">10610001</TD></TR></TBODY></TABLE><P>Have can I sort this in the script?</P></BODY></HTML> Wed, 23 May 2012 21:22:25 GMT 2012-05-23T21:22:25Z Order by in script https://community.qlik.com/t5/QlikView/Order-by-in-script/m-p/366426#M704025 <HTML><HEAD></HEAD><BODY><P>I am trying to sort the data below.</P><P>The sort order should be 1, 2 and 3.</P><P></P><P>This is what a have:</P><P></P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp; </P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" height="155" style="height: 157px; width: 342px;"><TBODY><TR><TD class="xl63" height="17" width="93">145</TD><TD class="xl63" style="border-left-style: none;" width="62">2007-10-15</TD><TD class="xl63" style="border-left-style: none;" width="59">4612A</TD></TR><TR><TD class="xl63" height="17" style="border-top-style: none;">145</TD><TD class="xl63" style="border-top-style: none; border-left-style: none;">2008-05-05</TD><TD align="right" class="xl64" style="border-top-style: none; border-left-style: none;">10610001</TD></TR><TR><TD class="xl63" height="17" style="border-top-style: none;">145</TD><TD class="xl63" style="border-top-style: none; border-left-style: none;">2008-05-05</TD><TD class="xl63" style="border-top-style: none; border-left-style: none;">4612A</TD></TR><TR><TD class="xl63" height="17" style="border-top-style: none;">145</TD><TD class="xl63" style="border-top-style: none; border-left-style: none;">2008-10-16</TD><TD align="right" class="xl64" style="border-top-style: none; border-left-style: none;">611015</TD></TR><TR><TD class="xl63" height="17" style="border-top-style: none;">145</TD><TD class="xl63" style="border-top-style: none; border-left-style: none;">2009-03-20</TD><TD align="right" class="xl64" style="border-top-style: none; border-left-style: none;">10610001</TD></TR></TBODY></TABLE><P></P><P>This is what I want to have:</P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" height="184" style="height: 186px; width: 341px;"><TBODY><TR><TD class="xl63" height="17" width="93">145</TD><TD class="xl63" style="border-left-style: none;" width="62">2007-10-15</TD><TD class="xl63" style="border-left-style: none;" width="59">4612A</TD></TR><TR><TD class="xl63" height="17" style="border-top-style: none;">145</TD><TD class="xl63" style="border-top-style: none; border-left-style: none;">2008-05-05</TD><TD align="right" class="xl64" style="border-top-style: none; border-left-style: none;">4612A</TD></TR><TR><TD class="xl63" height="17" style="border-top-style: none;">145</TD><TD class="xl63" style="border-top-style: none; border-left-style: none;">2008-05-05</TD><TD class="xl63" style="border-top-style: none; border-left-style: none;"><SPAN style="text-align: -webkit-right;">10610001</SPAN></TD></TR><TR><TD class="xl63" height="17" style="border-top-style: none;">145</TD><TD class="xl63" style="border-top-style: none; border-left-style: none;">2008-10-16</TD><TD align="right" class="xl64" style="border-top-style: none; border-left-style: none;">611015</TD></TR><TR><TD class="xl63" height="17" style="border-top-style: none;">145</TD><TD class="xl63" style="border-top-style: none; border-left-style: none;">2009-03-20</TD><TD align="right" class="xl64" style="border-top-style: none; border-left-style: none;">10610001</TD></TR></TBODY></TABLE><P>Have can I sort this in the script?</P></BODY></HTML> Wed, 23 May 2012 21:22:25 GMT https://community.qlik.com/t5/QlikView/Order-by-in-script/m-p/366426#M704025 2012-05-23T21:22:25Z