Execute Stored Procedure in Qlik Sense

[AjjuSid]

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. 

Qlik Sense Enterprise on Windows Sep 2020

Database: SnowFlake

[Anil_Babu_Samineni]

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

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