Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Qliker35
Contributor II
Contributor II

Qliksense load from stored procedure not working

Hi,

I have a stored procedure returning a table variable.

İnside Stored procedure i am declaring a table variable as

DECLARE  @Result TABLE

(

      CUSTOMER NVARCHAR(50),

      MATERIAL NVARCHAR(50) ,

  ORDERS int,

  STOCK int,

  DATE1 datetime  

)

at the end of the procedure i'm returning table variable as

SELECT * FROM @Result

and stored procedure returns a resultset.

I want to get this results into Qliksense

I've already tried

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

Load *;

SQL execute dbo.stored_procedure;

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

STOCK:

LOAD

CUSTOMER AS %KEY_CUSTOMER,

MATERIAL AS %KEY_STOCK,

MATERIAL AS %KEY_MATERIAL,   

ORDERS AS ORDERS,

STOCK AS STOCK,

Floor(NUM(DATE1))  AS [%KEY_CALENDAR];

SQL EXECUTE QlikSense.dbo."myproc";

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

result are allways empty.

Any suggestions will be much appriciated.

Thank you.

0 Replies