Aggregation in Script "Invalid Expression"

[#1]

Hi Qlikies,

It's the first time I try to aggregate in script and it doesn't work. Helps appreceated

This ist my (only) sourcetable.

%AGGR2	ANZPR.ZPRAES_AGGR	JAHRKW.AGGR	TC_KG.AGGR
1401832201135	2	201135	1407146
1402848201135	2	201135	1407146
1401528201135	1	201135	1407146
1405006201135	4	201135	1405006
1406580201135	2	201135	1405006
1402848201135	2	201135	1405006
1407318201135	1	201135	1405006

this is, how i try to aggregate

ZPRAES_AGGR2:

noconcatenate load

  JAHRKW.AGGR as JAHRKW.AGGR2,

  TC_KG.AGGR as TC_KG.AGGR2,

  sum(ANZPR.ZPRAES_AGGR) as ANZPR.ZPRAES_AGGR2

resident ZPRAES_AGGR

order by JAHRKW.AGGR,TC_KG.AGGR;

to receive

JAHRKW.AGGR2	TC_KG.AGGR2	ANZPR.ZPRAES_AGGR2
201135	1407146	5
201135	1405006	9

But what I receive is "Invalid Expression". Without the row" sum(ANZPR.ZPRAES_AGGR) as ANZPR.ZPRAES_AGGR2" the script runs trough.

thanks for your help

Birgit

[rwunderlich · Accepted solution]

You need to add a

GROUP BY JAHRKW.AGGR,  TC_KG.AGGR

-Rob

[#3]

uuups