Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
cancel
Showing results for 
Search instead for 
Did you mean: 
henryslk
Contributor
Contributor

how can I use a proc with parameters dynamically?

Hi, please I have a proc and it needs 2 parameters to return a result, I use this script to call this proc

LIB CONNECT TO 'Microsoft_SQL_Server_servidor';
[Data]:
SQL exec Prueba_1 @year = 2019, @var = 'A' 

But I need use this parameters dynamically, and choose the year since other consult, for example

[years]:
LOAD
[year];
SELECT year,
FROM BDData.dbo."years";

How can I make this?

Labels (1)
0 Replies