Qlik Community

Ask a Question

Connectivity & Data Prep

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

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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.