Qlik Community

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

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: 
geogou1973
Creator
Creator

Qlikview SAP HANA connector does not support group by in the script of select ?

Hello,

I am connecting in sap hana with qlikview sap hana connector 7.0.1.0

I write the following script 

SELECT
GJAHR,
MONAT
FROM table
GROUP BY GJAHR,
MONAT;

which is correct and does not run and a take the message

The field "MONAT" from the SELECT list is missing in the GROUP BY clause.

the sap connector does not support group by clause or something else happens ?

Can anyone knows and help me about this problem ?

Thank you in advance.

 

1 Solution

Accepted Solutions
Hakan_Ronningberg

Hi,

Try to remove the commas. This statement works in our test system:

select spart vtweg from vbak
group by spart vtweg

Regards,
Håkan

View solution in original post

3 Replies
geogou1973
Creator
Creator
Author

I tried to do the same sql with one dimension 

SELECT
MONAT
FROM table
GROUP BY 
MONAT;

and it worked. I don't know why for more than one dimension the connector fails.

Hakan_Ronningberg

Hi,

Try to remove the commas. This statement works in our test system:

select spart vtweg from vbak
group by spart vtweg

Regards,
Håkan

View solution in original post

geogou1973
Creator
Creator
Author

Hello Hakan.

It worked fine.

Thank you.