I wanted to sort the given Sap virtual table in Qlikview.

[pratikm11]

Hi,

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.

I have attached the expected sort result and Qlik output after using Order by MATNR, RESWK.

Expected Output:

Qlikview Output:

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.

Kindly help me resolve this issue.

[Gysbert_Wassenaar]

Changed to order of the fields on which the table is sorted on the Sort tab of the properties window of the table.