sum between two range in expression

[#1]

I want to do summation something like sum(Actual) but with condition "company >= 12001 and company <= 12099"

How to write this in expression, such thing possible in QlikView

[#2]

Sum({<company = {">= 12001 <= 12009"}>} Actual)

[Anonymous · Accepted solution]

Either use Sum(if(company >= 12001 and company<=12099, Actual))

or, Sum({$<company={'>=12001<=12901'}>} Actual)

[#4]

Thanks Johan