topic Aggr Sum in QlikView

Aggr Sum

bellesol — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have the following table:

Product	OrderID	Type	OrderSum$
A	1	1	100
A	1	1	200
A	2	1	500
B	4	1	600
B	4	2	100
B	5	1	800

I would like to calculate the sum of "OrderSum$" group by "OrderID" which the sum of the order is bigger then 400$ and the type of the order is 1 and display it by "product" -

for example: Product "A" has 2 orders the sum of orderID "1" is 300$ and the sum of orderID "2" is 500$, so only orderID ="2" should be displayed because the sum of the order is bigger then 400$

the final table should look like:

Product	OrderSum$
A	500
B	1400

I attached QVW for example.

Re: Aggr Sum

sunny_talwar — Wed, 20 Nov 2019 13:15:42 GMT

Try this

Sum(Aggr( If(Sum([OrderSum$]) >= 500, Sum([OrderSum$])) , Product, OrderID))

Re: Aggr Sum

lironbaram — Wed, 20 Nov 2019 13:22:05 GMT

this expressions should work for you

sum(aggr(if(sum({<Type={"1"}>}OrderSum$)>400,sum({<Type={"1"}>}OrderSum$)),OrderID,Product))

Re: Aggr Sum

bellesol — Thu, 21 Nov 2019 09:00:34 GMT

Thank you all!