Aggregation in Script "Invalid Expression"

Wed, 28 Dec 2011 16:11:18 GMT

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 — Wed, 28 Dec 2011 16:47:06 GMT

You need to add a

GROUP BY JAHRKW.AGGR, TC_KG.AGGR

-Rob

Thu, 29 Dec 2011 08:13:15 GMT

uuups

topic Aggregation in Script "Invalid Expression" in QlikView