topic Dynamic Table aggr(sum(Amount),Total) Please help in QlikView

Dynamic Table aggr(sum(Amount),Total) Please help

Thu, 20 Jan 2011 16:32:57 GMT

Using this function only calculates the first record ...

Help please

Thu, 20 Jan 2011 16:51:51 GMT

SUM(Amount) / AGGR(SUM(Amount), Total, Concepto)

Thu, 20 Jan 2011 16:59:10 GMT

Don't work.

Thu, 20 Jan 2011 19:54:09 GMT

Did you tried this ?

Sum(Amount)/Aggr(Sum(All Amount),Total)

johnw — Thu, 20 Jan 2011 20:19:00 GMT

Perhaps this?

sum(Amount)/aggr(nodistinct sum(Amount),Total)

If it isn't that simple, perhaps this?

sum(aggr(sum(Amount),Total,Concepto)
/sum(aggr(sum(Amount),Total)

Or maybe:

sum(aggr(sum( Amount),Total,Concepto)
/sum(aggr(sum(total <Total> Amount),Total,Concepto)

Fri, 21 Jan 2011 08:41:04 GMT

Thanks John,

You have given me the solution.
But perhaps we can do something more simple.
The divider can leave it with a simple sum.

Thank you very much to all

sum(Amount)/sum(TOTAL<Total>aggr(sum(Amount),Total)