topic Re: Aggr function problem in QlikView

Aggr function problem

Wed, 10 Jun 2015 19:58:48 GMT

I need a help....I would like to calculate the total amount of the suppliers with more than 1250000

=if(aggr(sum(Amount),SupplierID)>1250000,sum(Amount))

the formula is giving me the total amount not the sum of the amount for the ones with more than 1250000(Amount)

jonas_rezende — Wed, 10 Jun 2015 20:30:08 GMT

Hi.

Please, use the expression below:

Aggr(Sum({$<SupplierID= {"=sum(Amount) > 1250000"}>} Amount),SupplierID)

Hope this helps!

Anonymous — Wed, 10 Jun 2015 23:19:48 GMT

Hi, try

if(sum(Total<SupplierID>amount)>125000,sum(Total<SupplierID>Amount))

Regards!!,

Jannnet-

Anonymous — Thu, 11 Jun 2015 01:14:56 GMT

No aggr() required:

Sum({<SupplierID= {"=sum({1} Amount)>1250000"}>} Amount)

Thu, 11 Jun 2015 08:01:43 GMT

Exactly what I am looking for..Thank you!