topic How to Sort Category in SAP Report connector in QlikView https://community.qlik.com/t5/QlikView/How-to-Sort-Category-in-SAP-Report-connector/m-p/198098#M712043 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try to set the order by criteria within the SAP SQL statement.</P><P>You will find the syntax here:</P><P>http://help.sap.com/abapdocu_70/en/ABAPORDERBY_CLAUSE.htm</P><P></P><P>Regards,</P><P>Björn</P></BODY></HTML> Fri, 17 Dec 2010 11:13:43 GMT 2010-12-17T11:13:43Z How to Sort Category in SAP Report connector https://community.qlik.com/t5/QlikView/How-to-Sort-Category-in-SAP-Report-connector/m-p/198097#M712042 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>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.</P><P>Can we sort the Category while pulling the data from SAP Report.</P><P>Please suggest if there is a better way to do it.</P><P></P><P>Regards,</P><P>Vikram.</P></BODY></HTML> Fri, 17 Dec 2010 11:00:22 GMT https://community.qlik.com/t5/QlikView/How-to-Sort-Category-in-SAP-Report-connector/m-p/198097#M712042 2010-12-17T11:00:22Z How to Sort Category in SAP Report connector https://community.qlik.com/t5/QlikView/How-to-Sort-Category-in-SAP-Report-connector/m-p/198098#M712043 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try to set the order by criteria within the SAP SQL statement.</P><P>You will find the syntax here:</P><P>http://help.sap.com/abapdocu_70/en/ABAPORDERBY_CLAUSE.htm</P><P></P><P>Regards,</P><P>Björn</P></BODY></HTML> Fri, 17 Dec 2010 11:13:43 GMT https://community.qlik.com/t5/QlikView/How-to-Sort-Category-in-SAP-Report-connector/m-p/198098#M712043 2010-12-17T11:13:43Z