Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Help with resultset return by SQL stored procedure

Hi,

I am using SQL stored procedure to get data from the database, the stored procedure returns multiple tables as result set.

But in QlikView i am getting only one table i.e. first table of resultset, how can i play with others table returned by stored procedure.

I am using below syntax, plesae help me if i am doing anything wrong.

set v_FinancialYear = 2012-2013;

Resultset:

LOAD *;

SQL EXEC

RPT_Get_RecruitmentKPIData '$(v_FinancialYear)';

Thanks

2 Replies
trey_bayne
Contributor

Re: Help with resultset return by SQL stored procedure

I'm hitting the same issue here. Did you ever figure this out?

Re: Help with resultset return by SQL stored procedure

QlikView can only see the first result set returned by a stored procedure.

You will have to modify your stored procedure to output the data in a different way, either to separate tables that can loaded into QlikView, or build a single results table in the stored procedure that is populated with each result set in turn and then output at the end.

Community Browser