Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
rdsuperlike
Creator
Creator

What If question

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

3 Replies
Not applicable

Hope this is what you are looking for..

rdsuperlike
Creator
Creator
Author

Can you explain ur expression once?

Not applicable

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.