Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Passing listbox selected value as parameter to StoredProcedure in Qlikview

Greetings...!!!

While developing a Qlikview report I came across a scenario where I need to pass PlanYear value from a listbox bind up with values like ( 2005, 2006, 2007....2020 ).

I have called StoredProcedure like below :

Exec "XYZ_Reporting".dbo.GetYearToYearreport $(PlanYear);

Where PlanYear is my parameter which is the value selected in Listbox.

Now my question is how can I pass selected listbox value to Stored Procedure in Qlikview.

4 Replies
Not applicable
Author

Below links may help you ...

http://community.qlik.com/docs/DOC-3054

http://community.qlik.com/docs/DOC-2784

http ://www.citagus.com/citagus/blog/qlikview-writing-back-to-database/

* Remove space for 3rd link ...

Not applicable
Author

Hi,

have a variable which will read getSelectedValues(<required_filed>) and read that variable in the script.

Regards,

Neti.

Not applicable
Author

Thanks Abhishek for your response, could you please share the exact sysntex or sample lines how I can get this value and then feed to StoredProcedure.

Thanks

...Baljeet

Not applicable
Author

Above links are not helpfull per my scenario. I need refresh the report on basis of Listbox value selection.