Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

alialialiali
New Contributor

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.

Community Browser