Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is this implementable in QlikView?
************************************************************
1. [Selling Price] is Fixed.
2. When [Status] is DONE, [Buy Price] is Fixed.
3. When [Status] is WIP, [Target Buy Price] is [Selling Price]/[Target Ratio]
4. <Total Sell Price> = Sum([Sell Price])
5. <Actual+Target> = Sum([Buy Price]) + Sum([Target Buy Price])
6. <Overall Ratio> = <Total Sell Price>/<Actual+Target>
The objective is to do a What-If analysis where user can adjust the Target Ratios (using input boxes or sliders) to achieve a certain Overall Ratio.
************************************************************
Customer | Product | Sell Price | Buy Price | Target Buy Price | Target Ratio | Status |
A | 1 | 2200 | 2000.00 | DONE | ||
A | 2 | 3000 | 2500.00 | 1.2 | WIP | |
B | 1 | 2200 | 1692.31 | 1.3 | WIP | |
C | 3 | 5000 | 4545.45 | 1.1 | WIP |
Total Sell Price | 12400 |
Actual+Target | 10737.76 |
Overall Ratio | 1.15 |
May be using INPUTFIELD
INPUTFIELD [Target Ratio];
Target:
LOAD * INLINE [
Customer, Product, Status, Sell Price, Buy Price, Target Ratio
A, 1, DONE, 2200, 2000, 1.1
A, 2, WIP, 3000, , 1.5
B, 1, WIP, 2200, , 1.3
C, 3, WIP, 5000, , 1.1
];
May be using INPUTFIELD
INPUTFIELD [Target Ratio];
Target:
LOAD * INLINE [
Customer, Product, Status, Sell Price, Buy Price, Target Ratio
A, 1, DONE, 2200, 2000, 1.1
A, 2, WIP, 3000, , 1.5
B, 1, WIP, 2200, , 1.3
C, 3, WIP, 5000, , 1.1
];
Thank You! This is exactly what I needed.