topic aggr in load script? in QlikView

aggr in load script?

richnorris — Wed, 22 Sep 2010 15:41:19 GMT

I have a function:

sum(aggr([$(vCurrency) Volume],[Row ID_]))

that I want to move into the load script and store in a field, rather than calculating it in every chart. Is this possible?

richnorris — Wed, 22 Sep 2010 16:39:42 GMT

Or, is there a way of doing the equivalent?

danielrozental — Wed, 22 Sep 2010 21:41:44 GMT

I don't believe your expression makes much sense.

You can totalize values using group by

LOAD

Field1,

Field2,

sum(Field3)

Group By Field1, Field2

Regards