Qlik Community

QlikView Connectivity

Discussion board for collaboration related to QlikView Connectors.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
eoi-support
Contributor
Contributor

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