https://community.qlik.com/t5/QlikView/Sort-my-data-with-a-specific-order/m-p/1595186#M737257 <P>Hi evrybody,</P><P>I want to migrate an SQL script that is run by VB program on QlikView.</P><P>In my result by VB Program, the data are sorted like this&nbsp;<span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> :&nbsp;</P><P>- U<EM>myitem</EM></P><P>- Web<EM>myitem</EM></P><P><STRONG>- Za<EM>myitem</EM></STRONG></P><P><STRONG><EM>- </EM>Z@<EM>myitem</EM></STRONG></P><P><STRONG><EM>- </EM>Z-<EM>myitem</EM></STRONG></P><P>When i run by QlikView, the date are sorted like this&nbsp;<span class="lia-unicode-emoji" title=":face_with_rolling_eyes:">🙄</span> :&nbsp;</P><P>- U<EM>myitem</EM></P><P>- Web<EM>myitem</EM></P><P><STRONG><EM>- </EM>Z-<EM>myitem</EM></STRONG></P><P><STRONG><EM>- </EM>Z@<EM>myitem</EM></STRONG></P><P><STRONG><EM>- </EM>Za<EM>myitem</EM></STRONG></P><P>How can i proceed to have the same data with the same order ? I've tried on the sheet Sort on my table Box Properties and i've never change the script SQL</P><P>Thanks a lot for your answers&nbsp;<span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Wed, 25 Nov 2020 16:16:04 GMT Fanch 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Sort-my-data-with-a-specific-order/m-p/1595186#M737257 <P>Hi evrybody,</P><P>I want to migrate an SQL script that is run by VB program on QlikView.</P><P>In my result by VB Program, the data are sorted like this&nbsp;<span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> :&nbsp;</P><P>- U<EM>myitem</EM></P><P>- Web<EM>myitem</EM></P><P><STRONG>- Za<EM>myitem</EM></STRONG></P><P><STRONG><EM>- </EM>Z@<EM>myitem</EM></STRONG></P><P><STRONG><EM>- </EM>Z-<EM>myitem</EM></STRONG></P><P>When i run by QlikView, the date are sorted like this&nbsp;<span class="lia-unicode-emoji" title=":face_with_rolling_eyes:">🙄</span> :&nbsp;</P><P>- U<EM>myitem</EM></P><P>- Web<EM>myitem</EM></P><P><STRONG><EM>- </EM>Z-<EM>myitem</EM></STRONG></P><P><STRONG><EM>- </EM>Z@<EM>myitem</EM></STRONG></P><P><STRONG><EM>- </EM>Za<EM>myitem</EM></STRONG></P><P>How can i proceed to have the same data with the same order ? I've tried on the sheet Sort on my table Box Properties and i've never change the script SQL</P><P>Thanks a lot for your answers&nbsp;<span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Sort-my-data-with-a-specific-order/m-p/1595186#M737257 Fanch 2020-11-25T16:16:04Z