qsVariable Slider and Button Problems

[#1]

Hello, Everyone,

                        I've been using QS for months, and I met a problem regarding extension qsVariable.

                        What my current dashboard is list as below,

What I what to achieve with the help of qsVariable is,

1. By clicking different price buttons(qsVariable button), KPI and bar chart will change simultaneously.
2. By dragging slider bar (qsVariable slider), KPI and bar chart will change simultaneously.

For example, I click the button "$24/Bbl" (Similarly, 'Slider' to value 24), the NPV chart and KPI will change to the value, and that value only, which showed in the table below.

What I read and tried,

• https://community.qlikview.com/thread/200601
• http://https://qliktech.hosted.jivesoftware.com/docs/DOC-9077
• Set-up vBox and vSlider in Data Load Editor
• Using fx like Pick(Match($(vBox),24,32,40,48,56),"$24/Bbl","$32/Bbl",$40/Bbl","$48/Bbl","$56/Bbl")

Result,

I can not get what I want in the first place.

I've enclosed the files in attachment.  Anything would help and I would be highly appreciated your kind help.@andy weir

Regards,

Cheng

[paul_scotchford]

Hi Cheng

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

above.

cheers

Paul

[#3]

Paul,

        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.

Best,

Cheng

[paul_scotchford]

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.

[ogster1974]

‌Here is a simple working example that you can pick apart and might help you get to your solution.

Makes Sense to go round in circles

[reddy-s]

Hi Cheng,

I would suggest you to debug the extensions so that you will have a fair idea about what is happening in the background. You can edit the extensions to modify it a s required.

Thanks,

Sangram