Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

QlikSense Table from Stored Procedure

Hi,

I'm new to QlikSense but was wondering, is it possible to pull the results from a stored procedure inside a SQL database into a Qlik Table?  That is, can you do something like:

LIB CONNECT TO 'SQL DB';

QlikTable:

LOAD

  *;

SQL EXECUTE dbo.sqldb_storedprocedure_SelectAll;

If this is not possible, is there a work around to get similar results?

Thanks...

Nick

Tags (2)
1 Solution

Accepted Solutions

Re: QlikSense Table from Stored Procedure

It should work afaik. The sql statement is passed as is to the source database. If it returns a result set then that should be loaded into the table. The stored procedure can't return a cursor. If it doesn't work you can try creating a view in the source database and select the view as source table.


talk is cheap, supply exceeds demand
1 Reply

Re: QlikSense Table from Stored Procedure

It should work afaik. The sql statement is passed as is to the source database. If it returns a result set then that should be loaded into the table. The stored procedure can't return a cursor. If it doesn't work you can try creating a view in the source database and select the view as source table.


talk is cheap, supply exceeds demand
Community Browser