What If

[rdsuperlike]

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.

[ramoncova06]

you could do an applymap for each fruit

Don't join - use Applymap instead

[rdsuperlike]

I dont want to make chnages thorugh script.

This has to be done on front end through what IF

[Siva_Sankar]

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

[rdsuperlike]

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.

Or

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.