Set Modifier Question

Tue, 20 Sep 2011 12:17:26 GMT

Hello,

I'm new to set analysis. I'm trying to develop a table which will provide a breakdown of our rebate owed per product line. My problem is that the rebate on each product line is based on a different %.

For Example:

If my Category (Product Line) contains Product Line 1, Product Line 2,Product Line 3, etc., and I want to multiply these lines by 5%, 10% and 15% respectively, how could I create something similar to below:

Product Line: Net Sales Rebate Owed

Product Line 1 10,000 500

Product Line 2 20,000 2,000

Product Line 3 5,000 750

Would I need a different expression for each product line? I've tried something like =Sum(<[Product Line]={[Product 1]}> [Net Sales])*.05 but it hasnt gotten me anywhere. Any help would be appreciated.

Thanks

Re: Set Modifier Question

lironbaram — Tue, 20 Sep 2011 12:43:11 GMT

you dont need set analysis

here is a short example hope its helps you

topic Set Modifier Question in QlikView

Set Modifier Question

Re: Set Modifier Question