topic VISIBLE HIDE OBJECT in QlikView

VISIBLE HIDE OBJECT

Wed, 30 Sep 2009 15:38:54 GMT

Hello everyone!
I wanted to know how can I test with a macro, if an object is visible or not!
Thank you!
I await suggestions! [:'(]

Daniela

VISIBLE HIDE OBJECT

rwunderlich — Wed, 30 Sep 2009 16:28:29 GMT

If the object is hidden/shown by a Conditional Show, you can test the same expression with the Evaluate function. You can extract the conditional show expression from the object with something like:

ActiveDocument.GetSheetObject("id").GetProperties.GraphLayout.Frame.Show.Expression.v

although the exact call path may vary with the object type.

-Rob

VISIBLE HIDE OBJECT

Wed, 30 Sep 2009 19:00:57 GMT

Thanks Rob!
What you suggested is perfect!
Now the problem is to understand how to use education evaluate! I can not find even one example and in whatever way I feel, I always mistake!

set cp = Shtobj(i).GetProperties
if cp.GraphLayout.Frame.Show.Always = "Falso" then
msgbox(ObjCaption&" Condizione "&cp.GraphLayout.Frame.Show.Expression.v)

if cp.Evaluate(cp.GraphLayout.Frame.Show.Expression.v) then

msgbox(ObjCaption&" Condizione "&cp.GraphLayout.Frame.Show.Expression.v)
end if
end if

Grazie!

Daniela

VISIBLE HIDE OBJECT

rwunderlich — Thu, 01 Oct 2009 00:05:19 GMT

Daniela,

Evaluate is a member of Document. So the call to Evaluate would use ActiveDocument.

if ActiveDocumet.Evaluate(cp.GraphLayout.Frame.Show.Expression.v) then

-Rob