topic How do I update an object dynamical from a variable in QlikView

How do I update an object dynamical from a variable

Tue, 16 Jun 2009 22:01:34 GMT

How do I update an object dynamical from a variable. In this case i want to move a text object regarding the value in the variable "TX06TopStart".
But how should I do to put the variable in "pos.Top"


sub MoveObject
set sh = ActiveDocument.ActiveSheet
 set obj = sh.SheetObjects("TX06")
 set v = ActiveDocument.GetVariable("TX06TopStart")
 pos = obj.GetRect
 pos.Top = 185
 pos.Left = 40
 obj.SetRect pos
end sub

How do I update an object dynamical from a variable

Tue, 16 Jun 2009 22:13:26 GMT

Your variable holds the value you would like for pos.Top?

If so, then you need something like:

pos.Top = CInt(v.GetContent.String)

How do I update an object dynamical from a variable

Wed, 17 Jun 2009 13:00:22 GMT

Hi, thanks for quick answer. It´s working as you said.