Activate a Button when sheet opens using Trigger

[#1]

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 .

[matt_crowther · Accepted solution]

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

[#3]

Thanks Matt,

It worked like a charm!

Mike

[skiruthigadevi]

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