topic Re: Time Triggered actions in qlikview in QlikView

Time Triggered actions in qlikview

Wed, 21 May 2014 08:16:28 GMT

Hi All,

I have a new question regarding time triggered actions.

I need to reload my data at set times and then after this reload it should automatically print certain objects.

I am familiar with the post-reload functionality to print objects, that is not a problem.

Where it gets tricky is this:

I am not allowed to add scheduler events to my computer so the time triggered action should be in the file itself.

I have a general direction in where i think is the solution

should be something like.

If(TIme(Now()) = 8:00, Reload(), 0)

do you have an idea how i can make this work?

Re: Time Triggered actions in qlikview

tresB — Wed, 21 May 2014 08:21:38 GMT

Create a variable; assign value to it conditionally like, if (hour(now())=8, 1,0). Now use varibale trigger (Document prop->Triggers->Variable event trigger->On Change->Action->External->Reload

Re: Time Triggered actions in qlikview

Wed, 21 May 2014 08:38:42 GMT

Thank you, i think this should work, however, i dont know how to assign a value to a variable like that.

Re: Time Triggered actions in qlikview

Wed, 21 May 2014 08:46:51 GMT

There was allready a similar disscussion under Macro with a button to reload the data

The Problem you will get that you need a Timer which is running in the background or check the current time on every click you doing in your App.

Add an Var Value "=hour(now()) = 8,1,0)"

then goto "Variable event trigger" > "On Change" and add the Reload Trigger

or Run a Macro with "activeDocument.Relaod()" if you want to do some other stuff as an reload,

But something like this could degrade your Performance - if you are aren't able to schedule anything on your PC this would have a reason for sure - otherwise I would recommend to talk with your IT to allow it,

The best way should be an EDX Trigger to fire a Server reload and Data Push

Re: Re: Time Triggered actions in qlikview

vipin_mishra479 — Wed, 21 May 2014 09:40:52 GMT

Hi tresco,

here i have attached the application where

Document prop->Triggers->Variable event trigger->On Change->Action->External->Reload

this process is not working

Re: Time Triggered actions in qlikview

Wed, 21 May 2014 10:01:39 GMT

This is what i created with your input, but it does not seem to reload. any thoughts on that?

Re: Re: Time Triggered actions in qlikview

tresB — Wed, 21 May 2014 10:34:10 GMT

It seems that, reload action would not respond against any other trigger other than Button Press, which is not totally meaningless. However, with just a three-line macro, you can achiev the same. See the attahced sample.

Sub ReloadThisDoc

ActiveDocument.Reload

End Sub

Re: Time Triggered actions in qlikview

Wed, 21 May 2014 13:39:11 GMT

Somehow i cannot seem to get this to work. When I put the macro behind a textbox and click on it, it works, but not time triggered?

Re: Time Triggered actions in qlikview

imrencimen — Tue, 19 Apr 2016 08:59:00 GMT

Hi tresesco I try this for run my sending mail macro. when hour =8 value=1(changed) and send email. An hour later

hour =9 value=0(changed) and send second email. How can I provide just email sent vhen value=1 ?