topic Re: What if analysis / scenario in QlikView

What if analysis / scenario

Fri, 28 Jun 2013 01:13:23 GMT

Hi Guys,

not sure if this possible.

I would like to setup a slider for my markup %, so when I change my slider on a particular product in the table it will show the impact on my net profit.

Product	Sales	Markup %	Net Profit %	Slider
A	$500	25%	6%	1% 100% -------------------
B	$350	10%	2%	1% 100% -------------------
C	$425	12%	5%	1% 100% -------------------
D	$150	18%	12%	1% 100% -------------------

Thanks

Re: What if analysis / scenario

Gysbert_Wassenaar — Fri, 28 Jun 2013 18:20:00 GMT

No, inline sliders aren't possible. You could set up four sliders using four variables and use an if-statement in your chart expression to pick the variable that goes with the product.

Or perhaps you could define Markup % as an input field in the script. That allows you to change the values in the Markup % field in the chart directly.

Re: What if analysis / scenario

Sun, 30 Jun 2013 22:33:11 GMT

Hi Gysbert,

Thanks for your response, could you please provide me with some examples of how the if statements would look.

Thanks