Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Aggregation in Script "Invalid Expression"

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.

%AGGR2ANZPR.ZPRAES_AGGRJAHRKW.AGGRTC_KG.AGGR
140183220113522011351407146
140284820113522011351407146
140152820113512011351407146
140500620113542011351405006
140658020113522011351405006
140284820113522011351405006
140731820113512011351405006

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.AGGR2TC_KG.AGGR2ANZPR.ZPRAES_AGGR2
20113514071465
20113514050069


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

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Aggregation in Script "Invalid Expression"

You need to add a

GROUP BY JAHRKW.AGGR,  TC_KG.AGGR

-Rob

2 Replies
MVP & Luminary
MVP & Luminary

Aggregation in Script "Invalid Expression"

You need to add a

GROUP BY JAHRKW.AGGR,  TC_KG.AGGR

-Rob

Not applicable

Aggregation in Script "Invalid Expression"

uuups