I'm not seeing any of your calcs in the app using the variable from the slider.
e.g. Sum(NPV) , I'm not sure what your expected calc is to be , but for example if you
Sum(NPV)/$(vSlider) the KPI changes as expected.
As with all calcs in QS, you need to $Expand the variable inside the calc such as my example
Thanks for the detailed reply. I really appreciated that.
From your example, after input Sum(NPV)/$(vSlider) or Sum(NPV)/$(vBox) into KPI Expression, KPI and qsVariables components work interactively!
However, the KPI result is not the correct one, I think it's due to the expression. The OIL_PRICE vs NPV table in the first thread showed correlations between different price and NPV value.
With Paul's expression,
Hit button $56/BBL or slide to 56, KPI will show -1.74k, which is Sum(NPV) divided by 56.
What I want specifically,
Hit button $56/BBL or slide to 56, KPI will show 15.236k, which is shown in Table above.
I do know your expression is only for demonstration purpose. But could you give me some hints regard on the question above? Or is there any reference documentation or video regarding on Expression I could use?
I believe this is much closer to the best answer!
Thanks a lot.
If you are looking to put the NPV on the KPI value based on the variable that is selected from the slider for example, then NPV needs to be equated to the slider selection, hence your calc will hardcode the NPV in an 'IF' test, which is probably not the best approach as if NPV changes in the data then of course the calc has to change.