Qlik Community

Qlik Connectors Discussions

Discussion Board for collaboration regarding Qlik Connectors.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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.