sumif using count qualifier

Wed, 09 May 2012 23:16:33 GMT

I'm totally lost on this one. I'm trying to create multiple expressions to stack in a bar chart that sum up volume for products with the following criteria:

1. Sum of volume for products that are sourced by 1 Supplier within the quarter

2. Sum of volume for products that are sourced by 2 different Suppliers within the quarter

3. Sum of volume for products that are sourced by 3 or more different Suppliers within the quarter

Here's what I have so far for #2 for example:

=if(Count(DISTINCT SUPPLIER = 2), Sum(VOLUME))

What I still need: this count should be by <Quarter> and by <Product>, I don't know how to integrate those two things into this formula.

Please help, thank you!!!

Susan

topic sumif using count qualifier in QlikView

sumif using count qualifier