topic Re: Slider Variables with Varies a Compound Calculation in QlikView

Slider Variables with Varies a Compound Calculation

Thu, 17 Apr 2014 09:02:44 GMT

Hi all

I have a scenario analysis tab in my QV tab which allows the user to vary the Return on Investment (ROI) however I don't know how to recalculate the compounding return based on a slider value.

For Example....

If user sets the ROI slider to 5% then a return of £100 is

Yr 1 = 100 * 105% = £105

Yr 2 = 105 * 105% = £110.25

Or the user could put the slider to a value of 10% so

Yr 1 = 100 * 110% = £110

Yr 2 = 110 * 110% = £121

The key to the problem is how can I take the output from Yr 1 and put it as the input for Yr 2?

Let me know if the above isn't clear.

Thanks

Re: Slider Variables with Varies a Compound Calculation

MK_QSL — Thu, 17 Apr 2014 09:09:30 GMT

You can use Above function in this case.

More help can be given if you can provide some sample data.

Re: Slider Variables with Varies a Compound Calculation

Roop — Thu, 17 Apr 2014 13:41:14 GMT

Hi Anthony,

How about using the power statement as this is in effect a compound interest calculation:

100 * Pow(1.1,YearNumber)

and that should provide the value moving forward through your chart

Hope this helps!