Execute Stored Procedure in Qlik Sense

AjjuSid — Sun, 21 Aug 2022 19:35:38 GMT

Hi All,

I am trying to run a stored procedure using Parameters in Qlik sense, the script runs successfully but it does not give me the expected results.

Note: The Query for the sproc is parameterized meaning, It expects a parameter to be passed when calling it.

Script:

LIB CONNECT TO 'SNW_Datawarehouse_RO (Test)';

Test:
Load *;
SQL call DBO.test_sproc(8977000);

Expected Result:

When I am running the Sproc in the Database, it gives me the expected results such as Amount for the ID. as shown below in the screenshot.

Result in Qlik :

When I run the Script, it runs successfully. but it does not give me the Amount for the ID, it creates 'Sproc name' as Column and Parameter as value. I am looking to pull data with the parameter being passed.

Can Some experts please help with this?

@sinanozdemir @Bjorn_Wedbratt @Anil_Babu_Samineni

Thanks and Regards.

Sep 2020

Database: SnowFlake

Re: Execute Stored Procedure in Qlik Sense

Anil_Babu_Samineni — Sat, 27 Aug 2022 10:48:10 GMT

@AjjuSid What parameter you expect to be call in procedure?

Can you please explain a bit about your needs between DB and Qlik

topic Re: Execute Stored Procedure in Qlik Sense in App Development

Execute Stored Procedure in Qlik Sense

Re: Execute Stored Procedure in Qlik Sense