topic What If question in QlikView

What If question

rdsuperlike — Fri, 29 May 2015 16:47:40 GMT

I have attached my test qvw.

I want similar kind of requirement in my actual file.

I need a what if input box for days of transport pre,days of transport post (increments of 0.1 day) for each fruits and it should affect the specific product only.

for example:

I select a product and then want to chnage all or only 1 fruit's days of transport pre values

(these fruits to be chnaged should be only the associated fruits)

fruit salsa has apple and fruit cocktail has apple. but if i select fruit salsa then the what if should chnage the value of apple days of transport pre value only. It shouldnt affect the fruit cocktail apple days of transport pre value.

And No changes have to be done on the script.

Ny help is appreciated

Re: What If question

Fri, 29 May 2015 23:13:41 GMT

Hope this is what you are looking for..

Re: What If question

rdsuperlike — Mon, 01 Jun 2015 22:58:42 GMT

Can you explain ur expression once?

Re: What If question

Tue, 02 Jun 2015 09:28:48 GMT

The new expression added goes like this

SUM({<Products={"*"}>}[Days of transport Pre]) + SUM({$<1>}vIncrement)

'SUM({<Products={"*"}>}[Days of transport Pre])' - shows all the products irrespective of selections in Products field.

'SUM({$<1>}vIncrement)' - Adds in the increment value (using the 0.1 increments from the slider) for the current selections.