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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
gsbs
Contributor
Contributor

Error when executing procedure with QlikSense variables

 

Hello everyone,

Is it possible for me to use a variable defined within Qlik in a procedure?

Ex: In the Data Load Editor, I'm running the following command:

SQL exec DB.SCHEMA.PROCEDURE '$(vDataStart_test)', '$(vTask_test)' And the result of this is an error:

gsbs_0-1738611468990.png

 

Note that variables are literally calling the variable, not the value it returns.

Within the Qlik variables, I created vDataStart_test, which returns the getFieldSelections of a given field, and vTask_test, which returns the selection of this other field. And in qlik this works:

gsbs_1-1738611501442.png

 

The problem is when running the procedure in the data Load Editor. Has anyone gone through this? 
 

Labels (3)
1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Those variables will only be evaluated to a value in the UI. They have no access to the data model in the script. 

-Rob