5 Replies Latest reply: Feb 1, 2016 7:41 AM by Sangram Reddy RSS

    qsVariable Slider and Button Problems

      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,

      Capture.PNG

      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.

      Capture1.PNG

      What I read and tried,


      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

        • Re: qsVariable Slider and Button Problems
          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

            • Re: qsVariable Slider and Button Problems

              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.

              Capture1.PNG

               

              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

                • Re: qsVariable Slider and Button Problems
                  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.

              • Re: qsVariable Slider and Button Problems
                Andy Weir

                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

                • Re: qsVariable Slider and Button Problems
                  Sangram Reddy

                  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