Do you have any further information on getting this extension to work? I've unzipped it into c:\users\administrator\documents\qlik\sense\extensions, as well as the same path for the user sense_system. It's not showing up in the Charts tab in the editor. Is there anything else I need to do?
I am using the input box extension (reddys10/SR_InputBox · GitHub) . The input box take the value and stores it into a variable. I think make my calculation using the variable. The user enters a new value for an exchange rate and then the I take that value to convert to USD.
I got the extension to install; had to use the QMC, go to Extensions -> Import and import the zip file that's contained in the master zip file.
Now, how do I set it up? It's kind of confusing, as their are "fx" formula buttons in the Title, Subtitle, etc., but I don't see a way to create set up formulas in the Variable section. I figured out the "Alternative" is where you create your values and labels for those values; but, once again, the "fx" button for formulas is located in the Title section.
It took just a little bit of trial and error, but I figured out how to use the Variable extension.
Add a Variable object to your sheet.
Go to the Add Alternative section and add the values you wish to use for your what-if scenarios. In my case, I added 0, .05, .10, and .15 so I can do what-ifs with 5%, 10%, and 15% (and a zero to have no what-if).
Name your Variable object something recognizable in the "Name" field of the "Variable" section.
Create a new Measure in your Master Items; use the name of your new variable in the formula. In my case, I wanted to use my what if to increase an hourly rate by a given percentage. My Variable is called GPIRatePct. My hourly rate is called AvgHrRate. The formula for my new measure is: (Avg(AvgHrRate) * GPIRatePct) + Avg(AvgHrRate). I called my new Measure "What If GPI Rate".
Now you can use the new measure in a chart and it will be affected by changing the value of your Variable object.