topic Re: Entering Parameters in App Development

Entering Parameters

Anonymous — Thu, 17 Nov 2016 16:04:22 GMT

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

vlad_komarov — Thu, 17 Nov 2016 16:35:10 GMT

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:

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

Regards,

Re: Entering Parameters

Anonymous — Fri, 18 Nov 2016 09:34:27 GMT

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

vlad_komarov — Mon, 21 Nov 2016 15:21:50 GMT

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....