topic Re: sql stored procedure + input parameter in QlikView

sql stored procedure + input parameter

Tue, 03 Nov 2009 12:36:24 GMT

I m trying to execute sql stored procedure with 3 input parameter namely : B_year,B_month,B_type

I want qlikview to prompt me to enter those input parameter whenever i make refresh or some other means.

How can i do that?

Please Help.

sql stored procedure + input parameter

Anonymous — Tue, 03 Nov 2009 12:45:56 GMT

Hi Murabza,

You can use input boxes to store the input values in variables before passing them as parameters in your stored procedure call.

Example:

Let vParam1 = Input('Enter value for Parameter 1', 'Input box');

Then you just use vParam1 to pass the value.

How to execute stored procedures has been answered several times in the forums, here for example:

http://community.qlik.com/forums/p/19638/75070.aspx#75070

sql stored procedure + input parameter

Tue, 03 Nov 2009 13:40:11 GMT

Sorry for not being specific.

What i want is when i refresh my qlikview, it must prompt me to put values

i tried the following script which only prompt me to enter value but at the enfd i get an error.

sql

declare

Let

SQL

EXECUTE SP_SAMPLE @year,@month; @year = Input('Enter year value', 'Input box');

Let

@month = Input('Enter month value', 'Input box'); @year int,@month int;

sql stored procedure + input parameter

Tue, 03 Nov 2009 13:54:29 GMT

SQL

DECLARE @YEAR INT, @MONTH INT;

LET @YEAR=INPUT('ENTER YEAR VALUE','INPUT BOX');

LET @MONTH=INPUT('ENTER MONTH VALUE','INPUT BOX');

SQL EXECUTE SP_SAMPLE @YEAR,@MONTH

------------------------------------

The above code gives me error when i execute it,

but when i hard coded the input parameter it goes fine e.g SQL EXECUTE SP_SAMPLE 2008,8

---------------------------

WHAT CAN I DO?

sql stored procedure + input parameter

Anonymous — Tue, 03 Nov 2009 14:23:09 GMT

The input box popup is a QlikView function and will not work in an SQL statement like that.

You need to place it outside:

LET vYear=INPUT('ENTER YEAR VALUE','INPUT BOX');

LET vMonth=INPUT('ENTER MONTH VALUE','INPUT BOX');

SQL EXECUTE SP_SAMPLE '$(vYear)','$(vMonth)'

Ps. You might not need the quotations around the variables when calling them.. i.e. $(vYear) instead of '$(vYear)'

sql stored procedure + input parameter

Tue, 03 Nov 2009 14:39:11 GMT

Bingo, i finally got the answer i want.

Thank you just isn't enough! You're the best!

sql stored procedure + input parameter

Anonymous — Tue, 03 Nov 2009 14:52:39 GMT

Haha, thanks murabza! Glad to be of assistance

Re: sql stored procedure + input parameter

arturbrandys — Tue, 04 Oct 2016 14:43:13 GMT

Yes it works. Thank you.

Re: sql stored procedure + input parameter

mick1234 — Wed, 13 Mar 2019 09:24:01 GMT

Hi, and what about Qlik Sense Desktop or Enterprise? i cannot find input function 😞