Passing stored procedure Parameter values on the dashboard

[bisola1]

I have a SQL stored procedure that takes in a few parameters. How do I dynamically pass in these parameter values from the dashboard ? Instead of returning a large dataset each time, I only want to return the data set for the filters selected.

[RafaelBarrios]

hi @bisola1 

Take a look on this

https://community.qlik.com/t5/Qlik-Sense-Documents/Execute-a-Stored-Procedure-in-Qlik-Sense/ta-p/148...

and then

Load *;
SQL EXEC dbo.uspGetAddress @City = '$(var)';

But, from the dashboard?

I guess you can change a variable while working in visualization and then use a button to reload the app or better a partial reload.

I think you should take a look to direct query, so qlik trigger a query in every selection

https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularSt...

https://youtu.be/gBADJQXcIgI

Or maybe ODAG, we are big app call another for detailed info.

https://community.qlik.com/t5/Qlik-Sense-Documents/On-demand-App-Generation-ODAG-in-QlikSense/ta-p/1...

hope this works for you

best,

[bisola1]

thank you for your response @RafaelBarrios 

But am yet to get a solution

my scenario below

My requirement is to get all the product names into qlik sense at once. I am looking for a solution something like where I can supply Product Id = '*' and get all the product names into qlik sense at once.

someone also asked the same question here (link below) but couldnt get a solution

https://community.qlik.com/t5/Connectivity-Data-Prep/Execute-stored-procedure-with-parameters/m-p/16...

Please let me know if any solutions available for my requirement.

Thank you