topic Aggregate Function giving scaled up values in QlikView

Aggregate Function giving scaled up values

Thu, 13 Feb 2014 00:38:07 GMT

I have a table as follows:

And when I apply the aggregate function on duration as aggr(sum(DURATION),SYSTEM_ID) , I get the values totally scaled up.. I noticed they are multiplied 7 or 6 or 5 times than the expected values what could be the reason, the aggregated table is as follows:

Re: Aggregate Function giving scaled up values

hic — Thu, 13 Feb 2014 08:15:09 GMT

You should not use the Aggr() function like that. Change your expression to Sum(DURATION) only, and see what you get.

HIC