topic Re: Run Macro from trigger/selection in QlikView

Run Macro from trigger/selection

stabben23 — Wed, 28 Sep 2016 11:50:44 GMT

Hi,

Cant find a smart way to fire my macro "RefreshData". I have a macro that needs to be fired from inside Application.

I have variables vSecond =second(now(1)) , vReload= if($(vSecond)>50,1,0)

So when my vReload is 1 it should fire the macro.

Any actions the fits my requirement? I have test some but without success.

Re: Run Macro from trigger/selection

sinanozdemir — Wed, 28 Sep 2016 13:50:10 GMT

Hi,

Have you looked into "Variable Event Triggers" in Document Properties?

You may be able to accomplish what you need to, with this.

Hope this helps.

Re: Run Macro from trigger/selection

stabben23 — Wed, 28 Sep 2016 14:12:15 GMT

Hi Sinan,

yes, i have struggeling With that, But no success. My variable vReload changes to 1 when 50 second on systemclock.

So far so good, but now I have to in some way fire my macro who is inside "Edit Module".

Re: Run Macro from trigger/selection

sinanozdemir — Wed, 28 Sep 2016 14:18:06 GMT

Are you using "Run Macro" action from the external action type? If so, just grab the Sub/Macro name and place it into the box shown below:

I hope I understood your problem correctly.

Re: Run Macro from trigger/selection

stabben23 — Thu, 29 Sep 2016 05:31:39 GMT

Hi Sinan,

I can not have the trigger on Document Level OnAnySelect, when the variable becomes 1 it should trigger the macro.

I look for: variable=1, Select a Field and that Field triggers the macro or if the variable itself can trigger the macro.

You can test this by doing a variable like this if(now(1)>50,1,0) 1 run macro.

Re: Run Macro from trigger/selection

stabben23 — Thu, 29 Sep 2016 07:08:24 GMT

Here is my requirement, is it possible to Select Field Refresh With my Variable? Variable becomes 1 when Seconds >50. When this happens, Select Refresh. If my Field Refresh get selected I can add a Field Event trigger to run my macro.

Re: Run Macro from trigger/selection

tamilarasu — Thu, 29 Sep 2016 08:22:23 GMT

Hi Staffan,

I am not sure what is the purpose of reloading the dashboard every 50 seconds. I think, it's not a good idea. What If your dashboard takes more than 50 seconds to load all the data.? So I will not suggest to reload on every 50 seconds.

I have attached one solution, since you asked. I just used "Variable Event Trigger" option. If you have any questions, Let me know.

Re: Run Macro from trigger/selection

stabben23 — Thu, 29 Sep 2016 08:33:20 GMT

Thanks Tamil,

I'll check this very soon, 50 sec is just for test, I think I'll use every second minute instead. The application itself takes around 30 sec to reload.

Re: Run Macro from trigger/selection

stabben23 — Thu, 29 Sep 2016 09:36:29 GMT

Tamil, I'm confused here. It Works as expected in Your Application but not in my QV12 SR5. What Version have you build it in?

Re: Run Macro from trigger/selection

tamilarasu — Thu, 29 Sep 2016 09:50:06 GMT

Staffan,

I am using 11.20.XXXX. If my sample works in your desktop, then it should work in your file as well. Did you follow the same procedure.?

Re: Run Macro from trigger/selection

stabben23 — Thu, 29 Sep 2016 10:44:56 GMT

Hi Tamil,

I forgott the = sign in the variable. When a look in my text Box With the Variable I have $ expansion so it looks like the flag was 1,0.

But the variable it self was only the Expression.

Re: Run Macro from trigger/selection

tamilarasu — Thu, 29 Sep 2016 16:37:49 GMT

Staffan,

Create an inputbox and add our created variable vReloadTrigger using the inputbox wizard. Now, you should see 1 in the inputbox every 50 seconds and 0 after 60 seconds. If not, copy paste the expression from the above attached file and see whether you are able to see the values. Also, check whether you have entered same module name in the trigger action or not. If everything is ok, you can see the automatic reload window every 50 seconds. If you still face issues, please let me know.

Re: Run Macro from trigger/selection

stabben23 — Thu, 29 Sep 2016 20:08:08 GMT

No issue, works as expected

Re: Run Macro from trigger/selection

tamilarasu — Fri, 30 Sep 2016 06:31:36 GMT

Great Staffan. Please close the thread by marking correct answer. It will help others (who browse for the similar problem) to find the solution.