Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Trigger off of DB table refresh

I'm fairly new to Qlikview and I'm still trying to figure out a few things about triggers.  We have a database table that is dependent upon an external file.  The problem is there is no fixed date for that file to be delivered.  What is the best way to set up a trigger to have the QV application run once the database table as been uploaded?  We would like to use a separate database table that inserts a row when the table is updated, but I'm not sure what columns we would need and how to use it as a trigger.  Please help!

3 Replies

Re: Trigger off of DB table refresh

I think you will need EDX for this. See this document: Using EDX in QlikView 11


talk is cheap, supply exceeds demand
Not applicable

Re: Trigger off of DB table refresh

Is that the only way to do it?

Re: Trigger off of DB table refresh

You could make the database (or an etl tool) trigger execution of a batch script that executes a command to reload your qlikview document from the command line. Or you could code a solution in your favorite programming language / environment.


talk is cheap, supply exceeds demand
Community Browser