topic Re: Tiered Commission based on sales in QlikView

Tiered Commission based on sales

kstroupe — Mon, 26 Feb 2018 02:59:34 GMT

Hello,

I'm trying to figure out how to calculate TTL commission that is tiered based on Sales.

For example:

commission for sales 0 - 10,000 is 10%

commission for sales 10,001 - 20,000 is 12%

commission for sales 20,001 - 75,000 is 15%

commission for sales 75,001 - 100,000 is 17%

so for 50,000 in sales I would get 1000 + 1200 + 4500 = 6700 commission

Thank you.in advanced.

Kim

Re: Tiered Commission based on sales

sunny_talwar — Mon, 26 Feb 2018 13:09:28 GMT

May be using IntervalMatch and doing some pre-calculation for each tier. For instance, if the sales is 50,000, we know that it will have 2200 commission from the first two tiers + 50,000 - 20,001 * 0.15. So, for each tier pre-calculate the fixed number and focus on calculating the variable portion per tier.

Re: Tiered Commission based on sales

pablolabbe — Wed, 28 Feb 2018 09:07:02 GMT

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others

Re: Tiered Commission based on sales

kstroupe — Thu, 01 Mar 2018 19:01:00 GMT

Probably not the most efficient way, but the interval match wasn't working the way I really wanted.

I wrote variables and put this in the commission box.

=if($(vMax_Tax_Percentage) = .22, ($(vTier1)*.10) + ($(vTier2)*.12) +($(vBank_Amount) - $(vTier2)) *.22,
if($(vMax_Tax_Percentage) = .12, ($(vTier1) *.10) + ($(vBank_Amount) - $(vTier1)) *.12,
if($(vMax_Tax_Percentage) = .10, ($(vBank_Amount)*.10),0)))