Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

10dulkar
New Contributor II

Executing a stored procedure in Qlik Sense.

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..

2 Replies
OmarBenSalem
Esteemed Contributor

Re: Executing a stored procedure in Qlik Sense.

MVP
MVP

Re: Executing a stored procedure in Qlik Sense.

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'.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser