Minimize in groups

[#1]

Hi there

I found this thread in the archives but I cannot see the code that was reccomended. I was wondering if someone could help with this.

http://community.qlik.com/forums/p/15266/59562.aspx#59562

[Oleg_Troyansky]

Unfortunately, none of the old attachments could make it to the new forum...

Basically, the idea there was to use variables and "Show Conditions" that would make more than one table to get displayed or hidden. Depending on your application design, you could attach small macros to various events like activating a chart, or simply use buttons, or making a selection from the list of available chart groups, etc...

cheers,

Oleg

[#3]

Thanks Oleg, I will have ago at the macros.

[#4]

Hello,

QV Version 9 provide the option to create a button and use "ACTIONS" like Minimize (Restore) Object.

Actions are replacing some of the macros used today.

Rainer

[#5]

I solved the problem this way:

Sub Macro_Tables
set a=ActiveDocument.GetSheetObject("TB01")
set b=ActiveDocument.GetSheetObject("TB02")
if a.IsMinimized and b.IsMinimized then
a.Restore
else
a.Minimize
end if
End Sub


Sub Macro_Tables_2
set a=ActiveDocument.GetSheetObject("TB01")
set b=ActiveDocument.GetSheetObject("TB02")
if not a.IsMinimized and b.IsMinimized then
b.Restore
else
a.Minimize
end if
End Sub


Sub Macro_Tables_3
set a=ActiveDocument.GetSheetObject("TB01")
set b=ActiveDocument.GetSheetObject("TB02")
if not b.IsMinimized and a.IsMinimized then
b.Minimize
else
a.Restore
end if
End Sub




sub Macro_Group
call Macro_Tables
call Macro_Tables_2
call Macro_Tables_3
end sub

Of course this is useful only in case u are using 2 or max 3 tables.

russianblue