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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
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.