I don't understand the Aggr function, help..

[#1]

Hi QV users,

I am an accountant that uses QV for a year now. I don't understand the aggr function, can someone please help me understand how it works. I have two scripts one with the aggr function and the other not.

=if(Amount>10,'true')

=if(aggr(sum(Amount),Customer)>10,'true')

I used this script to create a dimension field, the field Amount is an expression.

I receive the same results, can someone help me uncerstand the difference between those two scripts,

Regards,

Aissam

[#2]

(aggr(sum(Amount),Customer)

I think that functions Sum amount separeted by dimension Customer...

Something like a Select Customer,sum(amount) from xxxxx group by Customer.

[#3]

John exlplained it well.

http://community.qlik.com/forums/t/30511.aspx