Solved: Re: Sum between values - Qlik Community

yvonne-c · ‎2017-05-04

Hi all

Please can you help change the following expression to include values between 20000 and 50000 - I just cannot get it to work!

=Sum(Aggr(If(Sum([Price]) <=50000 and Credit_code='A', Sum([Price])), ReferredTo))

Thanks

Anil_Babu_Samineni · ‎2017-05-04

May be this?

Sum(Aggr(If(Sum(Price) >= 20000 and Sum(Price) <= 50000, Sum(Price)), ReferredTo))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

Anil_Babu_Samineni · ‎2017-05-04

May be this?

Sum(Aggr(If(Sum(Price) >= 20000 and Sum(Price) <= 50000, Sum(Price)), ReferredTo))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

yvonne-c · ‎2017-05-04

Simple as that!!

Thankyou

PrashantSangle · ‎2017-05-04

Hi,

another possible way

1: sum(aggr(sum({<Price={">=20000<=50000"}>}Price),ReferredTo))

or

2: sum(aggr(if(price>=20000 and price <=50000,price),ReferredTo))

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

devarasu07 · ‎2017-05-04

=sum({<Price= {">=20000<=50000"},Credit_code={'A'}> } Price)