3 Replies Latest reply: Nov 21, 2016 10:21 AM by Vladimir Komarov RSS

    Entering Parameters

    Sean Drummond

      For those of us who are using data driven queries by parameter values (e.g. Date ranges), is there a way by which users can enter these parameter values via text box / drop down list which will return the data based on these values?

      To be clear, I'm not looking to return all data and filter it after it is returned. I want the parameter's to be dynamic allowing the query to return the data based on these parameters passed.

        • Re: Entering Parameters
          Vladimir Komarov

          You can use Variable in this case:

          There are few extensions available on the Branch that will allow your users to enter Variables' values, so your you just need to add these variables into your Measures:

          Like:

          Screen Shot 2016-11-17 at 10.33.17 AM.png

          The Measure above will show all data points between vDR1Start and vDR1End Dates...

           

          Regards,

          VK

            • Re: Entering Parameters
              Sean Drummond

              Thanks for the reply Vladimir

               

              My data is generated from a SQL stored procedure which requires a from and to date as parameter values.

              I haven't seen much information / solutions in Qlik (so far) that allows users to enter values and then generate the data based on these values.

              Qlik would appear to be more driven towards getting the data loaded and filter / tailor it after it's loaded as opposed to being generated on the fly.

                • Re: Entering Parameters
                  Vladimir Komarov

                  Sean,

                   

                  I have to agree with you - QS is not capable to handle that yet, unfortunately....

                  The only option at this point is to create an extension object that saves entered variables into some external (TXT, XML, CSV) file so they could be picked up by reload process....

                   

                  VK