Execute Stored procedure from QlikView

datashaw — Sat, 16 Nov 2024 04:43:10 GMT

Dear Exprets,

I'm looking for some assistance on below issue.

1. I'm trying to Execute SQL stored procedure from QlikView. example: SQL EXECUTE [xxx].[StoreProcedureName] '$(vStartDate)', '$(vEndDate)'
2. The particular stored proc have multiple temp tables with the SP.
3. The Data is not populated when I execute from QlikView.
4. But I can execute the same SP from SQL with the given parameters.

My question is Can I simply execute the SP in Qlikview or do I've only option to convert complete query into Qlikview. the reason its not a simple SP(around 400 line code)

please suggest me the solution

Re: Execute Stored procedure from QlikView

Brett_Bleess — Tue, 23 Jul 2019 21:24:46 GMT

This is most likely due to the Edit Script settings needing to be tweaked, you have to Allow the Execute there, see the attached screenshot.

Here is an article regarding running things via Publisher or Reload Engine as well, similar tweak that needs to be made in that case too:

https://support.qlik.com/articles/000021069

topic Re: Execute Stored procedure from QlikView in QlikView

Execute Stored procedure from QlikView

Re: Execute Stored procedure from QlikView