Solved: Dynamic Table aggr(sum(Amount),Total) Please help - Qlik Community

Report Inappropriate Content · ‎2011-01-20

Using this function only calculates the first record ...

Help please

Report Inappropriate Content · ‎2011-01-21

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)

Report Inappropriate Content · ‎2011-01-20

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

Report Inappropriate Content · ‎2011-01-20

Don't work.

Report Inappropriate Content · ‎2011-01-20

Did you tried this ?

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

johnw · ‎2011-01-20

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)

Report Inappropriate Content · ‎2011-01-21

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)