topic aggregate function problem in QlikView

aggregate function problem

Thu, 13 Feb 2014 00:34:17 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 problem

maxgro — Fri, 14 Feb 2014 20:14:03 GMT

could you post your doc?

Preparing examples for Upload - Reduction and Data Scrambling

Re: aggregate function problem

Fri, 14 Feb 2014 20:38:27 GMT

I have seen this in a few cases where there are duplicates.

Just try sum(aggr(sum(distinct DURATION),SYSTEM_ID)). This is not a solution but can help identify if there are duplicates in your model.

Thanks