topic Inconsistent results with SortBy - it toggles between ascending/descending in QlikView https://community.qlik.com/t5/QlikView/Inconsistent-results-with-SortBy-it-toggles-between-ascending/m-p/346375#M128157 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Hope the below thread link will be solve your doubt</P><P></P><P><SPAN>&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><A class="jive-link-external-small" href="http://community.qlik.com/message/209120#209120">http://community.qlik.com/message/209120#209120</A></P><P></P><P>Regards</P><P></P><P>Ashok</P></BODY></HTML> Wed, 11 Apr 2012 11:40:35 GMT Anonymous 2012-04-11T11:40:35Z Inconsistent results with SortBy - it toggles between ascending/descending https://community.qlik.com/t5/QlikView/Inconsistent-results-with-SortBy-it-toggles-between-ascending/m-p/346374#M128156 <HTML><HEAD></HEAD><BODY><P> <SPAN style="color: #800000; font-size: 12pt;">Sub Sort</SPAN></P><P><SPAN style="color: #800000; font-size: 12pt;"> </SPAN></P><P><SPAN style="color: #800000; font-size: 12pt;">set table=ActiveDocument.GetSheetObject("CH05")</SPAN></P><P><SPAN style="color: #800000; font-size: 12pt;">table.SortBy 6</SPAN></P><P><SPAN style="color: #800000; font-size: 12pt;"> </SPAN></P><P><SPAN style="color: #800000;"><SPAN style="font-size: 12pt;">s</SPAN><SPAN style="font-size: 12pt;">et Table =ActiveDocument.GetSheetObject("CH15")</SPAN></SPAN></P><P><SPAN style="color: #800000; font-size: 12pt;">table.SortBy 6</SPAN></P><P><SPAN style="color: #800000; font-size: 12pt;"> </SPAN></P><P><SPAN style="color: #800000; font-size: 12pt;">end Sub</SPAN></P><P><SPAN style="color: #800000; font-size: 12pt;"> </SPAN></P><P><SPAN style="color: #000000; font-size: 12pt;">This macro sometimes sorts in ascending order and sometimes in descending order. i want to sort only in Descending order. What will be the Macro. Please i need it urgently ??</SPAN></P></BODY></HTML> Wed, 11 Apr 2012 08:13:13 GMT https://community.qlik.com/t5/QlikView/Inconsistent-results-with-SortBy-it-toggles-between-ascending/m-p/346374#M128156 2012-04-11T08:13:13Z Inconsistent results with SortBy - it toggles between ascending/descending https://community.qlik.com/t5/QlikView/Inconsistent-results-with-SortBy-it-toggles-between-ascending/m-p/346375#M128157 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Hope the below thread link will be solve your doubt</P><P></P><P><SPAN>&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><A class="jive-link-external-small" href="http://community.qlik.com/message/209120#209120">http://community.qlik.com/message/209120#209120</A></P><P></P><P>Regards</P><P></P><P>Ashok</P></BODY></HTML> Wed, 11 Apr 2012 11:40:35 GMT https://community.qlik.com/t5/QlikView/Inconsistent-results-with-SortBy-it-toggles-between-ascending/m-p/346375#M128157 Anonymous 2012-04-11T11:40:35Z