topic Minimize in groups in QlikView

Minimize in groups

Wed, 27 May 2009 04:23:59 GMT

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

Minimize in groups

Oleg_Troyansky — Wed, 27 May 2009 11:30:59 GMT

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

Minimize in groups

Wed, 27 May 2009 11:44:00 GMT

Thanks Oleg, I will have ago at the macros.

Minimize in groups

Wed, 27 May 2009 15:00:23 GMT

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

Minimize in groups

Tue, 05 Jan 2010 12:36:54 GMT

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