topic Re: What if analysis scenario in QlikView

What if analysis scenario

infock12 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I would like some help with a what if scenario. The attached files is quite straightforward. I have 4 expressions. 1. Total Products manufactured, 2. Total Days it took to manufacture those products, and 3. What is the average Products Per Day. I have created a variable vUplift=0 and created a slider object linked to the 'Projections' column (4th expression). What I would like to have is:

Scenario 1:

If the average Products Per Day goes up, how many fewer days (TotalDays) I need to manufacture the same number of Products (TotalProducts). Basically, when the value in the Projection column goes up (through the slider), the value in TotalDays column should DECREASE simultaneously. The Total Products column should remain static.

Scenario 2

Similar to the above but the difference is I would like to know how many more Products (Total Products) I can manufacture when the average Products Per Day goes up. Here, the TotalDays will remain static but the Projection column and TotalProducts column should INCREASE.

Not sure if we can do this in the same table, but I am happy to do this in a separate table if required:

Thanks for your help in advance.

Re: What if analysis scenario

rahulpawarb — Mon, 30 Jan 2017 09:24:10 GMT

Hello Karthik,

Below is the draft solution for your requirement.

I have created two new expressions:

Label: Projected TotalProducts

Definition: Sum(DayCount) *vUplift

Label: Projected TotalDays

Definition: Sum(CompletedProducts)/vUplift

Also refer the attached application file.

Regards!

Rahul

Re: What if analysis scenario

infock12 — Mon, 30 Jan 2017 12:06:07 GMT

Hi Rahul,

Thank you very much for this. It works perfectly! I have just made a start with this and continue to develop further and let you know if any more questions.

Bw,

Karthik

Re: What if analysis scenario

rahulpawarb — Mon, 30 Jan 2017 12:10:49 GMT

Cheers,

Rahul