topic Activate a Button when sheet opens using Trigger in QlikView

Activate a Button when sheet opens using Trigger

Wed, 12 Jan 2011 15:30:18 GMT

I am using V10SR1 and trying to activate a button using a trigger when the sheet opens. The button works fine when manually selected (clicked) , but it will not activate using a trigger .

Activate a Button when sheet opens using Trigger

matt_crowther — Wed, 12 Jan 2011 18:04:13 GMT

From the Qlikview API Guide:

rem ** press button BU01 **
ActiveDocument.GetSheetObject("BU01").Press

Create a Macro with the above and call the macro from a Trigger which is run on Activation of the sheet.

Hope that helps,

Matt - Visual Analytics Ltd

Activate a Button when sheet opens using Trigger

Wed, 12 Jan 2011 18:35:25 GMT

Thanks Matt,

It worked like a charm!

Mike

Re: Activate a Button when sheet opens using Trigger

skiruthigadevi — Fri, 02 Feb 2018 22:00:55 GMT

Hello Matt,

I am trying to implement this logic in my application but it is not working. I have attached a sample application, could you kindly have a look when you have a chance?

As of now, when I click the button my metrics is getting cleared.

so now I am trying to automate the button click while opening the document instead of clicking it manually.

Thanks,

Kiruthiga