topic Re: Macro to run a button in QlikView

Macro to run a button

Tue, 04 Apr 2017 13:36:56 GMT

Hi All,

I'm trying to write a macro that 'clicks' a button. The reason for this is the button links to another application and transfers state, and from my knowledge there is no way to get a macro to transfer state.

Therefore if I can get a macro that simply 'clicks' on the button, by activating it or simulating an actual click on that button then I think it would work. I have however been unable to find any macro/function that does this and am wondering if anyone has come across something similar.

Many thanks for any help,

Jeremy

Re: Macro to run a button

m_woolf — Tue, 04 Apr 2017 13:51:04 GMT

From the API guide:

ActiveDocument.GetSheetObject("BU01").Press

Re: Macro to run a button

Tue, 04 Apr 2017 14:04:51 GMT

Thank you very much!

Looked all over Google, but I really should start looking in the API guide...

Thanks again,

Jeremy

Re: Macro to run a button

skiruthigadevi — Fri, 02 Feb 2018 21:53:18 GMT

Hi ,

Is there any syntax.for this macro for pressing a button on opening the sheet,I am trying to run this but its not working in my case. I have attached a sample for your reference.Could you kindly have a look when you have a chance?

What I am looking is for the button to get activated and clear the selections in my field when I open the application.

Thanks,

Kiruthiga

Re: Macro to run a button

tamilarasu — Fri, 02 Feb 2018 22:04:41 GMT

Hi Kiruthigadevi,

Why do you want use macros for this simple task? You can inbuilt functionalities to clear the field.

Re: Macro to run a button

skiruthigadevi — Fri, 02 Feb 2018 22:07:30 GMT

Hello Tamil,

Thanks for your time. I am trying to avoid this feature as it is not working in the ajax mode.

Thanks,

Kiruthiga

Re: Macro to run a button

tamilarasu — Fri, 02 Feb 2018 22:15:02 GMT

Please note that Macros might not work in AJAX client. You need to use OnOpen trigger option for both the cases (clear field or running a macro). Please see Bill's reply in the below thread.

AJAX with OnOpen macro

Re: Macro to run a button

skiruthigadevi — Fri, 02 Feb 2018 23:17:28 GMT

Actually we are migrating an application from IEPlugin to Ajax mode. The problem is on activatesheet and onleavesheet triggers are not working in ajax mode but they are working in the IEPlugin. So I am looking for some solution.

This button click is the one I found as an alternative. Is there any other alternatives do you suggest?

Thanks,

Kiruthiga

Re: Macro to run a button

tamilarasu — Mon, 05 Feb 2018 04:07:05 GMT

Hello Kiruthiga,

I am not sure but you can create a bookmark for the values that you want to set on open of a qlikview document or whatever the required layout state. Then create an OnOpen trigger action and use apply bookmark feature. Document Properties =>Triggers => OnOpen => Add Actions => Bookmark => Apply Bookmark => Type the bookmark ID => Press Apply => Click Ok. I think this should work but I haven't tried yet.

Good luck.

Re: Macro to run a button

skiruthigadevi — Thu, 08 Feb 2018 03:30:09 GMT

Hello Tamil,

Thanks for your reply. I created a bookmark but OnActiveSheet is not working for BookMarks as well in Ajax.

Thank you,

Kiruthiga

Re: Macro to run a button

tamilarasu — Thu, 08 Feb 2018 08:07:29 GMT

Hi Kruthika,

Please create a new discussion as this one is already closed and not related to your question anymore.

marcus_sommer‌ Any thoughts?

Re: Macro to run a button

marcus_sommer — Thu, 08 Feb 2018 08:42:23 GMT

I suggest to consider if this kind of usability adds really more value to the user experience? In my opinion it adds a lot of complexity without a significantly added value and that there is more "magic" if the user directly choose which sheets/objects with which selections he/she needs.

Beside this you might need some more trials (one or two shots aren't enough - you might need some dozens) to find out if all necessary configurations are set and/or if there are any dependencies between them - which options are set within the bookmark and/or is session recovery activated and/or probably some more. I could confirm that calling a bookmark will switch to the sheet to which its related to.

Further if you want to remain by this kind of logic you might need to adjust them a bit and/or replace and/or combine them with logic which might lead to similar results. This could for example be:

- using of url's: AJAX and URL parameters

- use of document-extensions

- using fieldselections to control the sheet-visibility

- Marcus

Re: Macro to run a button

skiruthigadevi — Fri, 09 Feb 2018 19:51:00 GMT

Sure Thank you!

Re: Macro to run a button

skiruthigadevi — Fri, 09 Feb 2018 20:03:30 GMT

Thanks Marcus. My application has almost 50 hidden sheets with OnLeaveSheet trigger as well. I am trying via BookMarks. But it is not working either.

I am calling BookMark via onActiveSheet actions -->BookMark--Id. As OnActiveSheet doesn't work in Ajax means it wont invoke BookMark.

Is there any other alternative do you have to call the BookMark when opening the sheet?

Attached a sample application for your reference.

Thanks,

Kiruthiga

Re: Macro to run a button

marcus_sommer — Mon, 12 Feb 2018 10:14:08 GMT

You could call the bookmarks with a button or maybe an OnChange of a variable or a fieldselections.

- Marcus

Re: Macro to run a button

skiruthigadevi — Mon, 12 Feb 2018 14:10:09 GMT

Hello Marcus,

Appreciate your time. Thanks a lot. The problem is the change has to get reflected when opening the sheet before doing selections or changes with in the sheet.

For example: All the metrics should be cleared when opening the sheet.

Do you have a sample application?

Thanks,

Kiruthiga

Re: Macro to run a button

marcus_sommer — Mon, 12 Feb 2018 14:46:35 GMT

If you used buttons with variables or fieldselections for switching the sheets you could also use this call to do all other actions which you need. For example your button mustn't just change a variable which disabled sheet X and enabled sheet Y - it could also select/deselect any fields, changing further variables, calling bookmarks and so on.

Whereby like above mentioned I don't suggest using such approaches. To get a stable usability with dozens of hidden sheets and by each sheets you need a varity of different further selections is really hard work. I have played some years ago for a special project with this kind of usability and it was just wasted time - to spend hours/days/weeks to make simple things a lot more complicated is not really a clever idea ... and for this reason I don't use it anymore and have also no samples with it.

- Marcus

Re: Macro to run a button

skiruthigadevi — Mon, 12 Feb 2018 15:37:00 GMT

Sure, I have started adding all those actions in all the navigation buttons to those corresponding pages.

Thanks,

Kiruthiga