Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Group By with QlikView SAP SQL Connector

Hello Members,

I just wanted to create a simple group by statement with the QlikView SAP SQL Connector.

SQL SELECT ABRSPERR , COUNT(*)

FROM EVER

GROUP BY ABRSPERR

;

Error: "Spezielle Datenquelle konnte nicht gelesen werden".

BUT: The SAP - Connector says that 10 rows have been transferred?

This is not possible?

What is the problem?

Best regards

1 Reply
Hakan_Ronningberg

Hi,

Try to remove the comma like:

SQL SELECT ABRSPERR COUNT(*)

FROM EVER

GROUP BY ABRSPERR

Regards,

Hakan