Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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.

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

View solution in original post

8 Replies
sunny_talwar

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

Anonymous
Not applicable
Author

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

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

Anonymous
Not applicable
Author

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

 

ItemAvg RetailPOS Qty WeekPOS $
A$1.6543670.95
A$1.4357781.51
A$1.47591086.73
A$1.67331755.11
A$1.65431870.95
A$1.64321952.48
A$1.63282045.64
A$1.60612197.6
A$1.62442271.28
A$1.77322356.64
A$1.66543089.64
A$1.78463181.88
A$1.81263647.06
A$1.78243842.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

sunny_talwar

You need this in a KPI box object?

sunny_talwar

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
Not applicable
Author

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

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

Best,

Sunny