topic Re: Discount Matrix in QlikView

Discount Matrix

hobanwashburne — Fri, 12 Jul 2013 14:55:11 GMT

Discount Matrix

Okay,

I have a discount matrix where each customer type gets a
different discount percentage on each part number based on what product family
the part number belongs to. The way it needs to operate is: A list of part
numbers is generated via other stuff (all of that works), but then the user
selects a customer from a different list (not linked to anything) and the appropriate
discount is applied.

Hopefully the attachment will be clearer.

Re: Discount Matrix

swuehl — Fri, 12 Jul 2013 15:12:22 GMT

Have you tried linking your tables? Maybe Family with FamilyCode using AS to rename one of the two fields?

Re: Discount Matrix

hobanwashburne — Fri, 12 Jul 2013 15:19:55 GMT

Yes,

If the tables are linked the Customer and Order list boxes are mutually exclusive. They need to combine to lookup the correct discount.

Re: Discount Matrix

swuehl — Fri, 12 Jul 2013 15:30:29 GMT

That's only because your CustomerType key values don't match (because of the CROSSTABLE LOAD, the values in the one table are text values only).

If you link your Families and correct the CustomerType key, it looks quite ok to me. Check attached.