Discussion Board for collaboration on QlikView Scripting.
It's the first time I try to aggregate in script and it doesn't work. Helps appreceated
This ist my (only) sourcetable.
this is, how i try to aggregate
JAHRKW.AGGR as JAHRKW.AGGR2,
TC_KG.AGGR as TC_KG.AGGR2,
sum(ANZPR.ZPRAES_AGGR) as ANZPR.ZPRAES_AGGR2
order by JAHRKW.AGGR,TC_KG.AGGR;
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
Go to Solution.
You need to add a
GROUP BY JAHRKW.AGGR, TC_KG.AGGR