topic Re: Passing listbox selected value as parameter to StoredProcedure in Qlikview in QlikView

Passing listbox selected value as parameter to StoredProcedure in Qlikview

Mon, 10 Feb 2014 21:18:00 GMT

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.

Re: Passing listbox selected value as parameter to StoredProcedure in Qlikview

Tue, 11 Feb 2014 04:20:00 GMT

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 ...

Re: Passing listbox selected value as parameter to StoredProcedure in Qlikview

Tue, 11 Feb 2014 05:01:51 GMT

Hi,

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

Regards,

Neti.

Re: Passing listbox selected value as parameter to StoredProcedure in Qlikview

Tue, 11 Feb 2014 14:42:27 GMT

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

Re: Passing listbox selected value as parameter to StoredProcedure in Qlikview

Tue, 11 Feb 2014 16:26:56 GMT

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