Qlik Community

Qlik Connectors Discussions

Discussion Board for collaboration regarding Qlik Connectors.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Highlighted

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

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
Highlighted
Creator
Creator

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

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.

Highlighted

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

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

Highlighted
Creator
Creator

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

Hello Hakan.

It worked fine.

Thank you.