Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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:
The problem is when running the procedure in the data Load Editor. Has anyone gone through this?
Those variables will only be evaluated to a value in the UI. They have no access to the data model in the script.
-Rob