topic What-If Analysis in QlikView

What-If Analysis

Anonymous — Thu, 15 Mar 2018 08:22:55 GMT

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

Re: What-If Analysis

sunny_talwar — Thu, 15 Mar 2018 15:09:16 GMT

May be using INPUTFIELD

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

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

];

Re: What-If Analysis

Anonymous — Fri, 16 Mar 2018 06:20:41 GMT

Thank You! This is exactly what I needed.