topic Re: Reload on External Event in QlikView

Reload on External Event

agni_gold — Mon, 02 May 2016 08:10:05 GMT

I want to reload my dashboard when my informatica task will completed. How can i do this , i saw one option in QMC at trigger option , External Event.

Please tell me steps to create such task.

Thanks

Agnivesh

Re: Reload on External Event

swuehl — Mon, 02 May 2016 08:19:57 GMT

You can do this using an EDX trigger:

Using EDX in QlikView 11

Re: Reload on External Event

agni_gold — Mon, 02 May 2016 08:25:28 GMT

I have tried in below way

I have created a simple reload task in QMC

and applied on external event trigger but when i am trying to implement this trigger it is asking for password. What would be the password for this.

Thanks

Agnivesh

Re: Reload on External Event

swuehl — Mon, 02 May 2016 08:27:17 GMT

You should set a password on creating the external event trigger in QMC.

Re: Reload on External Event

agni_gold — Mon, 02 May 2016 08:31:00 GMT

Yes i have done this , but now where can i setup the detail of external event ?

Re: Reload on External Event

Kushal_Chawda — Mon, 02 May 2016 08:33:19 GMT

see this

Reload process trigger on external event (e.g. completion of DW load)

Re: Reload on External Event

swuehl — Mon, 02 May 2016 08:49:13 GMT

Not exactely sure how you want to create the EDX trigger. If you want to use the command line tool, have a look for example at

Trigger QV Task using command line arguments

Re: Reload on External Event

agni_gold — Mon, 02 May 2016 08:53:52 GMT

Thanks Kushal ,

My condition is slightly different , actually in my dashboard i have a trend chart where i have used today() function to show data till today date.

But my requirement is that when my data warehouse task is not executed then my dashboard will show data till yesterday's date.

Could you please suggest on this.

Re: Reload on External Event

rrsrini2907 — Mon, 02 May 2016 15:12:17 GMT

Hi Agnivesh,

Just a suggestion.

Try creating a simple text file once the informatica job successfully runs.

Load the filetime of text file and replace the today() with this date.

Hope this will solve your problem.

Regards,

Srini.

Re: Reload on External Event

apechard — Tue, 19 Jul 2016 08:46:42 GMT

Hi,

You can execute your task with triggers by using QlikView QMSEDX downloadable program here

In the QMC in the properties of the task, Triggers tab:

- Add an element in the "Current Triggers"

- Choose to start the task "On an external event"

- Enter a password and confirm

- Save a .bat file containing the following command line:

"PathOfTheFolder \ QMSEDX.exe" -task = "NameOfTheTask" -qms = "NameOfTheQVServer" -password = "PasswordOfTheTask"

- You can execute this batch with your informatica or a Windows Task

Hope that helps

Angélique