topic Re: Retail TPR question in App Development

Retail TPR question

Anonymous — Mon, 18 Apr 2016 22:53:30 GMT

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.

sunny_talwar — Mon, 18 Apr 2016 23:59:23 GMT

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

Anonymous — Tue, 19 Apr 2016 02:13:47 GMT

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.

sunny_talwar — Tue, 19 Apr 2016 02:15:51 GMT

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

Anonymous — Tue, 19 Apr 2016 10:53:19 GMT

In this case, TPR sales is total dollar amount sold at less than $1.89/unit($ $1.99*0.95), or $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

sunny_talwar — Tue, 19 Apr 2016 10:54:52 GMT

You need this in a KPI box object?

sunny_talwar — Tue, 19 Apr 2016 10:59:34 GMT

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])

Anonymous — Tue, 19 Apr 2016 23:14:06 GMT

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])

sunny_talwar — Tue, 19 Apr 2016 23:15:16 GMT

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

Best,

Sunny