Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Partner - Specialist III
Partner - Specialist III

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

Anonymous
Not applicable
Author

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
Partner - Specialist III
Partner - Specialist III

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