topic Re: run sql stored procedure in QlikView

run sql stored procedure

mrbqlik2009 — Wed, 25 Nov 2020 16:16:04 GMT

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.

kfoudhaily — Wed, 17 Oct 2018 15:39:14 GMT

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

mrbqlik2009 — Sat, 20 Oct 2018 08:52:56 GMT

Hi,

supppose i create sql stored procedure like this:

create PROCEDURE [dbo].[mandeHesab]

@fromDate datetime,

@todate datetime

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