Reload on External Event

[agni_gold]

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

[swuehl]

You can do this using an EDX trigger:

Using EDX in QlikView 11

[agni_gold]

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

[swuehl]

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

[agni_gold]

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

[Kushal_Chawda]

see this

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

[swuehl]

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

[agni_gold]

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.

[rrsrini2907]

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.

[apechard]

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