Aggr to sum over rows

Wed, 30 Jul 2014 15:58:28 GMT

Hi,

I'm trying to use aggr to sum rows over two dimensions, however it's returning the expression total and not the sum of the rows. I cannot change the 'total mode' to 'sum of rows' as it won't work for my application, I need to do this with an aggr function, but am unable to do so.

Screen shot below illustrates issue:

I need to return 103.87 for each record in dim1 and dim2. When I try this with an aggr, it returns the quotient evaluated over the sum of the records in the aggr, 38.006, whereas I need the sum 103.87. The expression for sumrpc is:

sum(aggr(NODISTINCT
sum(rev)/sum(visits)
,dim1,dim2))

I've attached a sample, any help is welcome.

Thanks,

Matt

Re: Aggr to sum over rows

maxgro — Wed, 30 Jul 2014 16:21:12 GMT

not sure to understand, try

sum(total <dim1,dim2> aggr(sum(rev)/sum(visits),dim1,dim2,dim3))

Re: Aggr to sum over rows

Wed, 30 Jul 2014 16:44:45 GMT

Great work!!!

topic Re: Aggr to sum over rows in QlikView

Aggr to sum over rows

Re: Aggr to sum over rows

Re: Aggr to sum over rows