topic Minimizing several objects with a button in QlikView

Minimizing several objects with a button

oxiofrt — Tue, 26 Jan 2010 15:50:02 GMT

Hi,

Actions related to button are really useful. I use them to restore / minimize some of my charts.
Is it possible to specify to restore or minimize several objects within the same action ? How ?

I would like to avoid the use of variables.
Thanks a lot for your help !

Minimizing several objects with a button

Tue, 26 Jan 2010 20:15:33 GMT

The following macro minimizes all objects on the active sheet.

sub MinimizeAll
Objects = ActiveDocument.ActiveSheet.GetSheetObjects
For j = lBound(Objects) To uBound(Objects)
set obj = Objects(j)
obj.Minimize
next
end sub

/Fredrik

Minimizing several objects with a button

oxiofrt — Wed, 27 Jan 2010 08:44:40 GMT

Thanks a lot for your answer.
I can do it with acros but I would like to avoid using them. New actions available in QV9 often can replace them.

Something cool would have been to have the ability to specify several Objects ID in the action (as shown in the screen capture herefater).
Thanks , bye

Minimizing several objects with a button

Wed, 27 Jan 2010 09:42:51 GMT

Hi,

For button you can define more than one action, so why don't you try to add one action to minimize for each object you have in sheet?

Andris

Minimizing several objects with a button

oxiofrt — Wed, 27 Jan 2010 09:47:31 GMT

Thanks for your answer.

That is the way I proceed for the moment.

But I am not satisfied with it, because as soon as I have more than 5 objects to minimize, it would be really more useful to specify all of them into only one action

Mr. Qlikview, if you hear me :
- please add a possibility to find objects ID directly from the action form
- please add a list of values inside the formula assistant