Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

How to Sort Category in SAP Report connector

Hi,

Right now i'm trying to pull a report for SAP using report connector, the report runs over million records. I was able to see a category 19, but I'm not able to find the category's from 7 to 18 also I'm not sure if 19 is the last category in the report array. Its practically impossible to scan through each record to check for the category type.

Can we sort the Category while pulling the data from SAP Report.

Please suggest if there is a better way to do it.

Regards,

Vikram.

1 Reply
Not applicable

How to Sort Category in SAP Report connector

Hi,

Try to set the order by criteria within the SAP SQL statement.

You will find the syntax here:

http://help.sap.com/abapdocu_70/en/ABAPORDERBY_CLAUSE.htm

Regards,

Björn

Community Browser