topic Re: Sum between values in QlikView

Sum between values

yvonne-c — Wed, 25 Nov 2020 16:16:04 GMT

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 — Thu, 04 May 2017 08:37:03 GMT

May be this?

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

yvonne-c — Thu, 04 May 2017 08:39:42 GMT

Simple as that!!

Thankyou

PrashantSangle — Thu, 04 May 2017 08:44:31 GMT

Hi,

another possible way

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

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

Regards,

devarasu07 — Thu, 04 May 2017 08:46:17 GMT

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