topic Object Value in SQL Variable in QlikView

Object Value in SQL Variable

josueabdias91 — Wed, 25 Nov 2020 16:16:04 GMT

Good day dear collaborators, I am new using the Qlikview application and based on it I would like to know if it is possible to take the value of an object and introduce it in an SQL variable:

1.- Insert the value of the calendar date to ...

2. Insert the value of the object before the variable in the Script

SET @INT = "Value of the object"

In the event that this action could not be performed, could the value of the Qlikview object be assigned to a qlik variable in the Script?

Re: Object Value in SQL Variable

Gysbert_Wassenaar — Fri, 26 Oct 2018 15:57:52 GMT

Try: SET @INT = $(Desde);

Re: Object Value in SQL Variable

josueabdias91 — Fri, 02 Nov 2018 16:14:54 GMT

Thanks for your response.

Another question.

When the value of the variable is entered in the SQL Script, the data is only updated when the data is reloaded, is it possible that the script is updated automatically when saving the value of the variable in the SQL Script?

Re: Object Value in SQL Variable

Gysbert_Wassenaar — Sat, 03 Nov 2018 16:54:17 GMT

I don't understand your question. Why should the script be automatically updated? The script is only executed when the document is reloaded.

Re: Object Value in SQL Variable

josueabdias91 — Wed, 07 Nov 2018 17:42:49 GMT

thanks, it's what I needed to know