Discussion board where members can learn more about Qlik Sense Data Connectivity.
I am connecting in sap hana with qlikview sap hana connector 184.108.40.206
I write the following script
SELECTGJAHR,MONATFROM tableGROUP 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.
Try to remove the commas. This statement works in our test system:
select spart vtweg from vbakgroup by spart vtweg
View solution in original post
I tried to do the same sql with one dimension
SELECTMONATFROM tableGROUP BY MONAT;
and it worked. I don't know why for more than one dimension the connector fails.
It worked fine.