Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

answer4health - healthB4wealth (but no$ no health)

do any qlik people know how i can get the object that currently has the focus ? (similar to getsheet ...)

3 Replies
marcus_sommer

It's only possible per macro whereby the use of macros aren't really recommended: Macros are Bad. Nevertheless here an example from APIGuide.qvw:

rem ** minimize all active sheet objects on active sheet **

set s=ActiveDocument.ActiveSheet

objs=s.GetSheetObjects

for i=lbound(objs) to ubound(objs)

    if objs(i).IsActive then objs(i).Minimize

next

As an alternatively you could control which objects will be displayed with variables- or selection-conditions.

- Marcus

Not applicable
Author

Thank you Marcus, but I have a work around, I am sticking a plaster over the tabs that will cause problems …

and due to the acute shortage of technical skillz I will avoid macros.

bi

Not applicable
Author

Intuition tells me you have designed this product using the principles of

OOA&D which means it should not be too difficult to implement.

Innovation can come from anywhere, I don't think this one carries too much

risk

The work arounds are currently using macros or stick back plasters, for

reasons already discussed in the community I have chosen the latter.

Thanks for your help, clive