Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
josueabdias91
New 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
MVP & Luminary
MVP & Luminary

Re: Object Value in SQL Variable

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
MVP & Luminary
MVP & Luminary

Re: Object Value in SQL Variable

Try: SET @INT = $(Desde);


talk is cheap, supply exceeds demand
josueabdias91
New Contributor II

Re: Object Value in SQL Variable

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?

MVP & Luminary
MVP & Luminary

Re: Object Value in SQL Variable

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

josueabdias91
New Contributor II

Re: Object Value in SQL Variable

thanks, it's what I needed to know