Executing a stored procedure in Qlik Sense.

[10dulkar]

Hi All,

Trying to execute a stored procedure in Qlik Sense.

There are no errors displayed however, the execution does not return any rows.

When I execute the stored procedure in the database, it gives me ~1000 rows.

The stored procedure is creating temp tables and also inserting & updating those temp tables.

Tried doing some debugging & what I discovered is that the below lines are creating an issue :

select

col1,

col2,

col3,

credit = convert(Money,' '),

debit = convert(Money,' '),

into tempdb...final_table from Table1 A, Table2 B where Table1.No = Table2.No

and A.timestamp > = '1 jan 2010'

Now, if I were to comment out the lines :

credit = convert(Money,' '),

debit = convert(Money,' '),

The stored proc works fine & returns the expected no of rows through Qlik Sense.

Not able to figure out the solution. Any help would be much appreciated..

[OmarBenSalem]

Please refer to this; it might help :

Store a QlikSense table directly into an SQL table using the script.

[jonathandienst]

Your code does not appear to be a stored proc. I assume you are using MS SQL Server. The convert() function is failing because the string ' ' cannot be converted to a numeric type (money in this case) and the second convert has a trailing comma (or maybe that's just a typo on the post).

"Select...into" does not return a recordset, so this code as posted will fill the temp table but will not return any data to QS, so I am not sure what you mean by "returns the expected no of rows through Qlik Sense'.