topic Re: Setting slider to a value instead of zero through a variable in QlikView

Setting slider to a value instead of zero through a variable

Mon, 21 Oct 2013 20:26:09 GMT

Hello,

Rebate % calculated is 2.63%. I am trying to build what-if analysis to see what happens to margins which i increase or decrease rebate %.

To do this, i have used a slider and associated the slider to a variable. instead of assigning 0 value to the variable, i would like assign 2.63%.

if i assign the rebate % formula in variable editor, the value is not retained when i change the slider

Any ideas?

Thank you,

Vishal

Re: Setting slider to a value instead of zero through a variable

venkatg6759 — Mon, 21 Oct 2013 20:51:08 GMT

check the attached qvw. Hope it helps.

Thanks ,

Re: Setting slider to a value instead of zero through a variable

Mon, 21 Oct 2013 20:56:22 GMT

Hi Venkat,

my rebate would not be 2.63% constantly. it would change based on selection and the slide should automatically adjust to the value.

Thanks,

Vishal

Re: Setting slider to a value instead of zero through a variable

venkatg6759 — Mon, 21 Oct 2013 20:59:26 GMT

Can you try to paste the formula that you are using to calculate your rebate

Re: Setting slider to a value instead of zero through a variable

Mon, 21 Oct 2013 22:00:59 GMT

You can use an action to reset the variable if that's what you are looking for. Take a look at the attached document and see if it's what you are looking for.

Re: Setting slider to a value instead of zero through a variable

Tue, 22 Oct 2013 00:07:17 GMT

Thanks Rebecca and Venkat.

Instead you setting variable value to constant, i have set the variable to rebate % calculation and it started behaving dynamically.

Cheers!

Vishal