topic Re: What if Tool in QlikView

What if Tool

Fri, 31 Jan 2014 16:16:51 GMT

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.

Re: What if Tool

Josh_Good — Fri, 31 Jan 2014 18:08:25 GMT

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?

Re: What if Tool

Fri, 31 Jan 2014 18:46:40 GMT

Here is what I was thinking.

Inputs:

Result:

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

Re: Re: What if Tool

fkeuroglian — Fri, 31 Jan 2014 19:23:48 GMT

Hi, Please the attached file

good luck!

Fernando

Re: What if Tool

Clever_Anjos — Fri, 31 Jan 2014 19:26:49 GMT

"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

Re: What if Tool

Fri, 31 Jan 2014 19:31:52 GMT

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

Re: What if Tool

Josh_Good — Fri, 31 Jan 2014 22:16:42 GMT

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