Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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])
What is the expected output here? Can you may be elaborate a little?
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.
What is the calculation for TPR? How would you do it in Excel? Just don't know how the calculation take place
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
You need this in a KPI box object?
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])
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])
Great, I am glad you were able to figure it out in the end.
Best,
Sunny