Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
1 Reply
Hakan_Ronningberg
Employee
Employee

Hi,

Try to remove the comma like:

SQL SELECT ABRSPERR COUNT(*)

FROM EVER

GROUP BY ABRSPERR

Regards,

Hakan