Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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 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.

mrkachhiaimpshiveshsingh

5 Replies
Highlighted
Partner
Partner

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

Hi Pratik,

Is the index available in the Qlik Table as well?

What's the order logic in the first screenshot?

Felipe.

Highlighted
Partner
Partner

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

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.

Highlighted
Partner
Partner

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

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.

Highlighted
Partner
Partner

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

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.

Highlighted
Partner
Partner

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

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.