What if Tool

[#1]

Has anyone used Qlikview to create a what if tool.

I have seen some projection discussions, but nothing that will quite work as a full on what if tool.

[Josh_Good]

Yes, there are lots of ways to you QlikView for What-if analysis.  What does a "full on what if tool" look like to you?

[#3]

Here is what I was thinking.

Inputs:

A

B

C

D

Result:

Z

If I modify A, B and D how will that change Z

Then I need to be able to say if I want Z what should A, B,C, and D look like

[fkeuroglian]

Hi, Please the attached file

good luck!

Fernando

[Clever_Anjos]

"If I modify A, B and D how will that change Z" Fernando show will how to

"Then I need to be able to say if I want Z what should A, B,C, and D look like" like Excel "goal seek", Qlikview does not provide a native way of doing this

[#6]

Hi Fernando

You can find really nice examples of What-If analysis in this book http://www.packtpub.com/learning-qlikview-data-visualization/book

Lukasz

[Josh_Good]

There are a few examples on the QlikView Demo site.  Here are my favourites:

Order and Inventory Management - On the "What-If" sheet

Sales Compass - on the "Forecast" sheet