8 Replies Latest reply: Apr 19, 2016 7:15 PM by Sunny Talwar

# Retail TPR question

A TPR is a temporary price cut of at least 5% from the regular price.

I now have the attached file, the question is

What is the total TPR penetration (TPR sales/total sales)? Assume regular price is \$1.99.

How could it be done in SENSE? Thanks.

• ###### Re: Retail TPR question

What is the expected output here? Can you may be elaborate a little?

• ###### Re: Retail TPR question

A simple straight table is good. I actually have hundreds of items. I just want to two columns,

one is item name, the other column is TPR penetration for each item, That's it. thanks.

• ###### Re: Retail TPR question

What is the calculation for TPR? How would you do it in Excel? Just don't know how the calculation take place

• ###### Re: Retail TPR question

In this case, TPR sales is total dollar amount sold at less than \$1.89/unit(\$ \$1.99*0.95), or \$950.19

 Item Avg Retail POS Qty Week POS \$ A \$1.65 43 6 70.95 A \$1.43 57 7 81.51 A \$1.47 59 10 86.73 A \$1.67 33 17 55.11 A \$1.65 43 18 70.95 A \$1.64 32 19 52.48 A \$1.63 28 20 45.64 A \$1.60 61 21 97.6 A \$1.62 44 22 71.28 A \$1.77 32 23 56.64 A \$1.66 54 30 89.64 A \$1.78 46 31 81.88 A \$1.81 26 36 47.06 A \$1.78 24 38 42.72 950.19

What I want to know is the percentage of TPR sales/all Sales. in this case, it is 950.19/1883.03 = 50.46%,

need help on how to do the culculation in QLIK SENSE. Thx

• ###### Re: Retail TPR question

You need this in a KPI box object?

• ###### Re: Retail TPR question

I am getting 49.54% using this expression:

Sum(Aggr(If(Sum([Avg Retail]) >= (1.99*0.95), [Avg Retail] * [POS Qty]), Item, Week))/Sum([Avg Retail] * [POS Qty])

• ###### Re: Retail TPR question

Thanks, actually the correct calculation should be

Sum(Aggr(If(Sum([Avg Retail]) <= (1.99*0.95), [Avg Retail] * [POS Qty]), Item, Week))/Sum([Avg Retail] * [POS Qty])

• ###### Re: Retail TPR question

Great, I am glad you were able to figure it out in the end.

Best,

Sunny