Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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 ...
Hi,
have a variable which will read getSelectedValues(<required_filed>) and read that variable in the script.
Regards,
Neti.
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
Above links are not helpfull per my scenario. I need refresh the report on basis of Listbox value selection.