topic Re: What If in QlikView

What If

rdsuperlike — Thu, 28 May 2015 01:24:56 GMT

Hi,

I have below kind of scenario:

Products (in list box)

Fruit Bar

Fruit Plate

Fruit salad

etc

Fruits Days for pre transport Days for post transport

apple 1.3 1.6

mango 1.2 2.1

Pear 2.5 1.7

Orange 2.7 2.4

Process A values change based on a equation for eg: If Product = Fruit Bar and the Fruits are apple, mango, then Initial date + 3 * days for pretransport for apple + 24* days for post transport for apple + 3 * days for pretransport for mango + 24* days for post transport for mango + some other constant value

Date 1/1 1/2 1/3 1/4 1/5 1/6

Process A

I want to find out a solution to do what if on the values in green and italics.

Bcz what if done on them would make changes to the process A equation.

Any input is appreciated.

Re: What If

ramoncova06 — Thu, 28 May 2015 01:34:29 GMT

you could do an applymap for each fruit

Don't join - use Applymap instead

Re: What If

rdsuperlike — Thu, 28 May 2015 03:19:49 GMT

I dont want to make chnages thorugh script.

This has to be done on front end through what IF

Re: What If

Siva_Sankar — Thu, 28 May 2015 03:25:47 GMT

You can refer the What if analysis example with steps for implementing your logic. check here https://community.qlik.com/docs/DOC-7221

Re: What If

rdsuperlike — Thu, 28 May 2015 04:57:26 GMT

This is straight forward example using single variable.

I want to change various numbers like apple for pre transport, mango for post transport and so on.

Probably usage of more than one variable.

for ex:

--So when I click on Product as fruit bar there might be just 2 fruits available and in that now if i change apple days for pre transport value through what if how will it affect my Process A equation.

One more xample would be when i click on fruit salad product there might be just 3 fruits available and in that now if I change mango days for post transport value thorugh what if how will it affect my Process A equation.

I hope my example is not confusing.