Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
pratikm11
Partner - Contributor
Partner - Contributor

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

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:

Output.png

Qlikview Output:

Qlik_Output.png

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.

1 Reply
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.


talk is cheap, supply exceeds demand