topic I wanted to sort the given Sap virtual table in Qlikview. in QlikView https://community.qlik.com/t5/QlikView/I-wanted-to-sort-the-given-Sap-virtual-table-in-Qlikview/m-p/79270#M778172 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a virtual table from SAP in which they are sorting the table on MATNR and RESWK. When i sort the same table in Qlikview, i'm getting different sort result.</P><P></P><P>I have attached the expected sort result and Qlik output after using Order by MATNR, RESWK.</P><P></P><P>Expected Output:</P><P><IMG __jive_id="200529" alt="Output.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/200529_Output.png" style="height: 83px; width: 620px;" /></P><P></P><P>Qlikview Output:</P><P><IMG __jive_id="200530" alt="Qlik_Output.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/200530_Qlik_Output.png" style="height: 102px; width: 620px;" /></P><P>The highlighted record in red show match the sort order, so that i can use Firstsorted value function to fetch and show only that record.</P><P>Kindly help me resolve this issue.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT pratikm11 2020-11-25T16:16:04Z I wanted to sort the given Sap virtual table in Qlikview. https://community.qlik.com/t5/QlikView/I-wanted-to-sort-the-given-Sap-virtual-table-in-Qlikview/m-p/79270#M778172 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a virtual table from SAP in which they are sorting the table on MATNR and RESWK. When i sort the same table in Qlikview, i'm getting different sort result.</P><P></P><P>I have attached the expected sort result and Qlik output after using Order by MATNR, RESWK.</P><P></P><P>Expected Output:</P><P><IMG __jive_id="200529" alt="Output.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/200529_Output.png" style="height: 83px; width: 620px;" /></P><P></P><P>Qlikview Output:</P><P><IMG __jive_id="200530" alt="Qlik_Output.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/200530_Qlik_Output.png" style="height: 102px; width: 620px;" /></P><P>The highlighted record in red show match the sort order, so that i can use Firstsorted value function to fetch and show only that record.</P><P>Kindly help me resolve this issue.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/I-wanted-to-sort-the-given-Sap-virtual-table-in-Qlikview/m-p/79270#M778172 pratikm11 2020-11-25T16:16:04Z Re: I wanted to sort the given Sap virtual table in Qlikview. https://community.qlik.com/t5/QlikView/I-wanted-to-sort-the-given-Sap-virtual-table-in-Qlikview/m-p/79271#M778173 <HTML><HEAD></HEAD><BODY><P>Changed to order of the fields on which the table is sorted on the Sort tab of the properties window of the table.</P></BODY></HTML> Mon, 23 Apr 2018 15:53:21 GMT https://community.qlik.com/t5/QlikView/I-wanted-to-sort-the-given-Sap-virtual-table-in-Qlikview/m-p/79271#M778173 Gysbert_Wassenaar 2018-04-23T15:53:21Z