Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

mitzyturbo
New Contributor II

Entering Parameters

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.

3 Replies
vlad_komarov
Valued Contributor III

Re: Entering Parameters

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

mitzyturbo
New Contributor II

Re: Entering Parameters

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.

vlad_komarov
Valued Contributor III

Re: Entering Parameters

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

Community Browser