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

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

pratikm11 — Mon, 23 Apr 2018 13:15:25 GMT

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 should match the sort order, so that i can use Firstsortedvalue function to fetch and show only that record.

Kindlyanyone help me resolve this issue.

mrkachhiaimp‌shiveshsingh‌

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

felipedl — Mon, 23 Apr 2018 15:32:25 GMT

Hi Pratik,

Is the index available in the Qlik Table as well?

What's the order logic in the first screenshot?

Felipe.

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

pratikm11 — Mon, 23 Apr 2018 15:54:31 GMT

Hi Felip,

No index is not available in qlik table, but if i do use the RowNo() function both qlik and sap has the same "1891" number as index.

The first screenshot has order by EBELN,EBELP,ETENR.

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

felipedl — Mon, 23 Apr 2018 16:01:55 GMT

Hi,

I've seen that if the order is done by EBELN on the first screenshoot, the value 87458 should be bellow the 87450, not how you have on your first screenshot.

Since the other columns are exactly the same, the only one affecting the sort is the EBELN, and the first screenshot doesn't seem to be doing the sort you're saying.

The Qlik screen is more accurate according to your ording strategy.

I'm assuming your doing the order in a different way and it Seems quite random to me since that's the only differentiating field.

Other thing is, that you have a filter on your table, that might be doing something different.

Felipe.

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

pratikm11 — Mon, 23 Apr 2018 16:14:57 GMT

Hi,

In Sap they first sorted a virtual table according to EBELN,EBELP,ETENR and copied the exact same table into another virtual table later on which they sorted on the basis of Matnr and Reswk.

I'm sorry, the first screenshot (Sap virtual table) is based on the sort order of Matnr and Reswk also the filter is just for that particular Matnr(100111145000900) and in qlik i firstly sorted on the basis of EBELN,EBELP,ETENR

and took the resident of it and sorted according to matnr and reswk also tried it in front end have selected the same Matnr in qlik i.e. 2nd ss.

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

felipedl — Mon, 23 Apr 2018 16:24:37 GMT

To me, the SAP ordering is just being done by the row index, and not by any other type of data you have on your virtual table. The other fields just seem randomly put other than the Index column.

Maybe i'm not understanding it correctly, but if you apply your same sort logic to your virtual table, it should look exactly as the table you see on Qlik.

Felipe.