topic Textobject in QlikView

Textobject

Wed, 09 Mar 2011 16:05:05 GMT

Hi,

What is the command/syntax to input the data to textobject from vbscript. I want to print the values in the database table in to the text object.

Code is working fine using the msgbox. But not able to print in the text object.

Textobject

Anonymous — Wed, 09 Mar 2011 16:26:18 GMT

Use a variable in the text box, for example:
=vText
and, it is easy to assign a value to this variable in a macro.

Textobject

Wed, 09 Mar 2011 16:39:13 GMT

Thanks Michael,

I have tried it using the set content as well but not working. Also it is not one value the table has multiple values and it has to loop through. Any idea. Please suggest

Textobject

Anonymous — Wed, 09 Mar 2011 19:13:12 GMT

A simple solution is to concat all your possible field values, and use the result in variable.

sub GetDataToTextBox
ActiveDocument.Variables("vText").SetContent ActiveDocumentEvaluate("concat(distinct, FieldName, '; ')") , true
end sub

Textobject

Wed, 09 Mar 2011 20:03:38 GMT

Thanks Michael,

Please correct me if i am wrong. I feel the script will work only for the data already loaded in Qlikview. I am trying to establish the connection in macro and pull the data and try to put it in the textobject.hence it may not work . I am getting error while trying to run this script

Textobject

llauses243 — Wed, 09 Mar 2011 20:17:34 GMT

Hi,

Put point (pls see image attached)

Good luck, Luis.

Textobject

llauses243 — Wed, 09 Mar 2011 20:19:46 GMT

Also out comma ...

Textobject

Anonymous — Wed, 09 Mar 2011 20:24:29 GMT

That's correct, thanks.

And - yes, the data must be in QlikView for this to work.

Textobject

Wed, 09 Mar 2011 20:43:06 GMT

Thanks Michael for the logic ,

I have used the similar logic by concatenating the strings using vb script and resolved the issue.

Textobject

Anonymous — Wed, 09 Mar 2011 20:54:41 GMT

I used to do it in a loop in macro, but it was before the 'Evaluate" method was introduced. It helps to simplify a lot, not only in the cases like this.
More important - you've got it to work one way or another.