Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
See why Qlik was recognized for the seventh year in a row – and discover how we can help you tackle your data integration challenges. Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
agni_gold
Specialist III
Specialist III

Reload on External Event

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

9 Replies
swuehl
MVP
MVP

You can do this using an EDX trigger:

Using EDX in QlikView 11

agni_gold
Specialist III
Specialist III
Author

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
MVP
MVP

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

agni_gold
Specialist III
Specialist III
Author

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

swuehl
MVP
MVP

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
Specialist III
Specialist III
Author

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
Creator
Creator

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
Partner - Contributor II
Partner - Contributor II

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