What-If Analysis

[Anonymous]

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

[sunny_talwar · Accepted solution]

May be using INPUTFIELD

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/ScriptPrefixes/Inputfi...

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

];

[Anonymous]

Thank You! This is exactly what I needed.