topic What If Scenario in QlikView

What If Scenario

Dayna — Mon, 21 Mar 2011 11:46:18 GMT

Hello Everyone..

I haven't got any data to test this on yet, so unfortunately I cannot upload an example. I am planning on creating a what if scenario, but rather than if the price is higher, etc, it's based on 'What If we don't do something', so if we planned to NOT create a work order, what effect would this have on our stock levels, etc..

Say we have a field called stock, and a field for Work Order called WO_ID, and the WO_ID has a field related to how much stock it would used called WO_Stock. Could you advise as to how best to achieve this scenario?

Many thanks for your help!

Kind Regards,
Dayna

SV:What If Scenario

Mon, 21 Mar 2011 14:04:27 GMT

I think you need to give a more specific example for with the information given why don't you just don't subtract the stock used by the work order from the total stock? Or if it is implicitely done in the data already adding it?

/Michael

What If Scenario

Oleg_Troyansky — Mon, 21 Mar 2011 14:42:29 GMT

I'd suggest adding an INPUTFIELD "Include/Exclude" and associate it with the WO.The field (like a "flag" field" would get 1 for included orders and 0 for excluded orders. Let the users enter 0 or 1 for each Order.

Then, in all calculations, you can multiply certain values by the flag, or use it in Set Analysis, to only included those orders that are marked with 1.

What If Scenario

Dayna — Mon, 21 Mar 2011 15:35:59 GMT

Hello,

Many thanks for your reply! I'm quite a novice when it comes to InputFields, do you have an example where I can associate it with a field?

Kind Regards,
Dayna

What If Scenario

Oleg_Troyansky — Mon, 21 Mar 2011 15:47:19 GMT

It's actually very simple - you declare the field to be an INPUTFIELD and then load it as a part of your usual load. For example:


INPUTFIELD OrderIncluded;

LOAD DISTINCT
 OrderNumber,
 1 as OrderIncluded
RESIDENT
 Orders
;
[\code]</body>

What If Scenario

deepakk — Mon, 21 Mar 2011 15:47:49 GMT

hi Dayna,

The attach application is the combination of above discussion. Click on the whatifQty expression to change the value.

I hope this helps.

What If Scenario

Dayna — Mon, 21 Mar 2011 15:55:52 GMT

Hello Both,

Many thanks for your help! I'm sure that'll do the job!!

On a different note Deepak, how did you create the custom style on your Pivot Table? I was trying to do that the other day! 🙂

Many thanks,
Dayna

What If Scenario

deepakk — Tue, 22 Mar 2011 03:41:46 GMT

hi Dayna,

Press Ctrl +G , it will enable design grid or in Design tab there is a design Grid button, click on it.

Right click on the pivot table --> Custom Format Cell. Then click on any rwo to change the colors.