topic Re: Dynamically Highlight a Button on a Sheet for an Active Window in QlikView

Dynamically Highlight a Button on a Sheet for an Active Window

Fri, 01 May 2015 13:56:33 GMT

I'm attempting to configure a Button on a Sheet, linked to another sheet, to highlight when a Window(i.e. Chart) is active on the specific sheet. Does anyone know if this is possible?

Re: Dynamically Highlight a Button on a Sheet for an Active Window

Gysbert_Wassenaar — Fri, 01 May 2015 13:59:20 GMT

That's not possible.

Re: Dynamically Highlight a Button on a Sheet for an Active Window

Fri, 01 May 2015 14:02:34 GMT

Thanks for the response.

Re: Dynamically Highlight a Button on a Sheet for an Active Window

awhitfield — Fri, 01 May 2015 14:11:12 GMT

Hi Jeff,

looking around the community, the ability to an action to a chart object, disappeared with the demise of V10

Andy

Re: Dynamically Highlight a Button on a Sheet for an Active Window

Anonymous — Fri, 01 May 2015 14:29:01 GMT

You can create a macro that checks if an object is active or not. The problem is - the objects on "another sheet" are all inactive. Just try to activate an object and switch between the sheets back and forth.

The best you can do is to define if the object "was" active before you move to a different sheet.

Here is an example of a macro (variable vCH01Active will be True or False):

sub test

set ch=ActiveDocument.GetSheetObject("CH01")

set v=ActiveDocument.GetVariable("vCH01Active")

v.SetContent ch.IsActive, true

end sub