topic Sum function in script not possible in QlikView

Sum function in script not possible

michael_maeuser — Wed, 21 Dec 2011 09:22:26 GMT

Hi, I need to deploy a sum function in my script. Does anyone have an idea why this is not working (see attached pic)? This is the error message: ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Die QLIK ProBatch300 2009R2 DE DEV.dbo.DEVEL Pro Batch 3_00 DE$Bank Account Ledger Entry.Amount (LCY)-Spalte ist in der Auswahlliste ungültig, da sie nicht in einer Aggregatfunktion und nicht in der GROUP BY-Klausel enthalten ist. (THIS MEANS: Amount (LCY) is invalid, since it is not in an an aggregate function and not in the Group by clause.)
SQL SELECT "Bank Account No_", "Posting Date", "Amount (LCY)"
FROM "QLIK ProBatch300 2009R2 DE DEV".dbo."DEVEL Pro Batch 3_00 DE$Bank Account Ledger Entry"
GROUP by "Bank Account No_", "Posting Date". Thanks in advance! Michael

Sum function in script not possible

jagan — Wed, 21 Dec 2011 09:26:01 GMT

Hi,

Try this

SQL SELECT "Bank Account No_", "Posting Date", Sum("Amount (LCY)")

FROM "QLIK ProBatch300 2009R2 DE DEV".dbo."DEVEL Pro Batch 3_00 DE$Bank Account Ledger Entry"

GROUP by "Bank Account No_", "Posting Date"

Regards,

Jagan.

Sum function in script not possible

vijay_iitkgp — Wed, 21 Dec 2011 09:28:06 GMT

You are applying Group by on SQL Select . You need to do it at Load level.

Load

Sum(C)

Group By A,B ;

SQL Select A,B,C from........................

Hop this will Help You.

Regards

VIjay

Sum function in script not possible

michael_maeuser — Wed, 21 Dec 2011 09:54:27 GMT

Perfect! Thanks so much!