Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Not applicable

how to call stored procedure and pass parameter as a selected date

Hi,

How to execute stored procedure in qvw file and  pass selected date as a parameter to that storded procedure

Administrator

2 Replies
Highlighted
Partner
Partner

Re: how to call stored procedure and pass parameter as a selected date

Hi,

you can follow this syntax:

first you have to create a variable for each parameter you need to pass to the Store Procedure. In this example, let's suppose you just have a single date parameter:

let vDate = '2013-01-01' //here is important to use the same format that is used in the database

Store_Procedure_table:

Load * ;

SQL EXECUTE DB.OWNER.STORE_PROCEDURE '$(vDate)'; //with the last part you're passing the needed parameter

If you had several parameters you can separate them with commas and alwas with the $-expansion and between single quotes,

regards,

Employee
Employee

Re: how to call stored procedure and pass parameter as a selected date

SQL EXECUTE ProcName 'param1', 'param2';