Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
josueabdias91
Contributor II
Contributor II

Object Value in SQL Variable

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 ...

Calendario.jpg

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

SET @INT = "Value of the object"

Calendario2.png

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?

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
Gysbert_Wassenaar

Try: SET @INT = $(Desde);


talk is cheap, supply exceeds demand
josueabdias91
Contributor II
Contributor II
Author

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?

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
josueabdias91
Contributor II
Contributor II
Author

thanks, it's what I needed to know