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

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

get values from objects ?

Hello Qlikview community

Unfortunately, I have found anything suitable in the forum. Is there a way by (Object ID) to read values? For example, I would like to read a value of a textboxes and fit elsewhere into a formula?

I thought of something like

getElementById(TX21). value ?

Thank you!


Best Regards,

1 Solution

Accepted Solutions
Not applicable
Author

I don't think you can do it without a macro. Using a macro and setting the text box value to a variable, you can do:

Sub Test
set mytext = ActiveDocument.GetSheetObject("TX01")
ActiveDocument.Variables("vTest").SetContent mytext.GetText, true
End Sub


The variable must already be created and TX01 is the Object Id of your Text Box.

View solution in original post

2 Replies
Not applicable
Author

I don't think you can do it without a macro. Using a macro and setting the text box value to a variable, you can do:

Sub Test
set mytext = ActiveDocument.GetSheetObject("TX01")
ActiveDocument.Variables("vTest").SetContent mytext.GetText, true
End Sub


The variable must already be created and TX01 is the Object Id of your Text Box.

Not applicable
Author

Hi,

Is it possible to do vice versa. To set the value of the textobject through macro