Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Partner
Partner

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
Highlighted
MVP & Luminary
MVP & Luminary

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

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