Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You need to add a
GROUP BY JAHRKW.AGGR, TC_KG.AGGR
-Rob
uuups