topic Re: what-if analysis in QlikView

what-if analysis

Thu, 28 Feb 2013 21:55:29 GMT

Hi everybody,

i studied the what if analysis sample documents. Well, now i'm trying to build a what if analysis with this template but i need to simulate a report in a more specific and "complex" way.

Ideally the situation is the following:

TABLE1 -->a sort of input table in which i need to set manually some values:

fields:

1) Customer type (1,2 etc.)

2) % Discount --> (value to set manually) for each Customer type

and

TABLE2 (or pivot or waterfall chart)

fields:

1) customer type (1,2 etc.)

2) customer type % --> the values of this field must change dynamically, according to the different customer type % tha i manually insert in the first one,

Is it possible? Which is the formula/objects to use for this kind of simulation?

Many thanks in advance,

Marcelo

Re: what-if analysis

hectorgarcia — Thu, 28 Feb 2013 22:07:08 GMT

Hi Marcelo, I think you can use the logic presented in one of the samples that comes with the installation

you can find it at program files\qlikview\examples\documents\executive dashboard.qvw.

The tab name where the logic to buid what if scenario is "waht if"

if this helped pls mark the answer as correct or helpfull answer.

Hector

Re: what-if analysis

Fri, 01 Mar 2013 21:11:22 GMT

Ciao Hector,

i just started from this sample, but what i want is an input box with multiple row like a table.

I want to fill this table with customer type1,2,3 and the related discount %.

In the sample i have only an input box filled with a unique value...this is not a table.

Do you think that the only way is to use an external table in excel or so on, and re-charge anytime when i update this one?

if this is the only way.. i think that qlikview is not the best solution for a multiple and complex what if analysis..

but i hope to find a way with Qv file.

thanks in advance,

Marcello

Re: what-if analysis

Sat, 02 Mar 2013 00:45:28 GMT

Hi Marcello

Have you tried using input fields rather than variables? Load a field called "related discount" in your customer table in the script. Then use

Inputfield [Related Discount];

to mark it as being able to be changed.

then open the customer, related discounts fields in a tbale box (not straight table chart object) and you will find that you can edit the field. The [related Discount] will act just like a normal field, except you can add values in it.

Hope this helps!

Erica

Re: what-if analysis

Sat, 31 Aug 2013 06:09:13 GMT

Hi Mbozzar,

I am trying to do the same thing, and haven't found a way. Have you figured out? If so, would you mind share your QV document with me? Thank you.