Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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,
VK
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.
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