Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mrbqlik2009
Contributor III
Contributor III

run sql stored procedure

Hi,

I have a sql stored procedure with 2 parameters.

and in qlikview i have a table, button and two inputbox.

I want when user click button, stored procedure execute with inputbox as parameter and see result in table.

2 Replies
kfoudhaily
Partner - Creator III
Partner - Creator III

hello, sub fonction might help

but sub is a script fonction wich means you need to reload the script for the sub to be executed.

maybe there are some other solutions to your issue, please provide context information in order to suggest solution

QlikView Qlik Sense consultant
mrbqlik2009
Contributor III
Contributor III
Author

Hi,

supppose i create sql stored procedure like this:

create PROCEDURE [dbo].[mandeHesab]

@fromDate datetime,

@todate datetime

as

(select * from dbo.test where fDate = @fromDate and tDate=@todate)

I want pass the fromdate and todate from inputbox in qlikview and fetch data from sql.