Relatively new to QlikView so yet to delve into anything beyond the standard display functions. In essence, I have the following
A set of Box's (static set of 5)
Box 1
Box 2
Box 3
Box 4
Box 5
For each box there will be a number of items in the box. Each item has a percentage saving attached. For example
Item 1 - 10%
Item 2 - 9%
Item 3 - 8%
Item 4 - 12%
There is a compound saving calculation depending on the number of items you have and the order of priority they are chosen in. For example you will always get the allocated saving for the first item that goes into the box. The percentage saving for the next Item (priority 2) will be calculated as a compound based off that first item percentage and then so on with the next item etc.
If you choose Item 2 as your first priority you are guaranteed to get the 9%. If you were then to choose Item 3 as the 2nd priority it will no longer be 8% - it will be reduced to 7% based on the fact you have rebaselined your figures after the first choice. i.e. 100% - 9% = 91% (example Excel attached)
Box 1 Item Savings
Item 2 - 9%
Item 3 - 7%
Total Saving 16%
What I would like to know is how I can choose a priority per Box for the Item savings to ensure the percentages are correct. I then need to aggregate the total savings for all boxes and the total savings for each Item number across boxes.
Hopefully that makes sense. Apologies for the long winded explanation.
