topic Re: SUM IF (FROM TO) in QlikView

SUM IF (FROM TO)

300sss300 — Wed, 25 Nov 2020 16:16:04 GMT

I have lets say 100 customers under the Field name "Customer Number" in excel sheet.

I want to see sum in chart of only customers from 15 to 26.

What will be the expression If I want to use "Sum (If([Customer Number].........................."

or If I use PICK Function

Best Regards

sunny_talwar — Wed, 10 Aug 2016 08:14:01 GMT

How about this:

Sum({<CustomerNumber = {'>=15<=26'}>} Sales)

Anonymous — Wed, 10 Aug 2016 08:14:36 GMT

use set analysis

sum({<[Customer Number]={'>=15<=26'}>} ...

pls try

Anonymous — Wed, 10 Aug 2016 08:14:40 GMT

you can try with set analysis provide 'Customer Number' contains numbers 1...........15.....26 and assuming aggregation on 'sales'

sum ( { <Customer Number={">=15<=26"}> }sales)