topic Re: Run a Macro every 5 seconds in QlikView

Run a Macro every 5 seconds

hmjason7 — Tue, 17 Mar 2015 12:17:05 GMT

Hi All,

I have a macro that I would like to run every 5 seconds. What is the best way of doing this?

The macro basically selects every possible value for a given field. So if I have a button with the macro "Test" as an action, every time I click on it, the field "Field" will select a different value each time.

But naturally I don't want to have to keep clicking on this every 5 seconds. How can I automate this process, i.e. have this macro run every 5 seconds in the background?

Sub Test

ActiveDocument.getField("Field").select ActiveDocument.Evaluate("minstring({1}if(Field>'$(=Field)',Field))")

end Sub

Cheers,

Jason

Re: Run a Macro every 5 seconds

agni_gold — Tue, 17 Mar 2015 12:18:42 GMT

Are you using Qlikview server ?

Re: Run a Macro every 5 seconds

hmjason7 — Tue, 17 Mar 2015 12:20:33 GMT

No, currently I am just demoing this on the desktop.

Re: Run a Macro every 5 seconds

agni_gold — Tue, 17 Mar 2015 12:28:35 GMT

So without server you cannot do this ,

Do one thingh , create a button and add the action on it to run the macro (But it is a manual process user have to click on the button )