topic Re: Trigger on External Event in Qlik View in QlikView

Trigger on External Event in Qlik View

mhmmd_srf — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Could you please help me to implement Trigger on External event in Qlikview.

Basically we need to do Stored Procedure option.

DW can provide query to the same server we are pulling data down from.
This query can show us if anything is still running and we can then go into wait loop and keep polling every X minutes until it’s finished.

Is this doable in Qlikview?

Thanks,

Sarif

Re: Trigger on External Event in Qlik View

NadiaB — Sat, 20 Jul 2019 20:18:51 GMT

Hi @mhmmd_srf

You might try Supporting Tasks option.

Kind Regards.

Re: Trigger on External Event in Qlik View

Brett_Bleess — Thu, 08 Aug 2019 21:33:27 GMT

If you are running in the 12.30/November 2018 track, you have access to the new File Exists trigger, which you could use your stored procedure to dump a file to a location we check, and once it appears, the task kicks off, the trick is to be sure to run an External Supporting task after the other task to delete the file, otherwise things will just keep triggering.

https://help.qlik.com/en-US/qlikview/November2018/Content/QV_HelpSites/Whats_New_in_QlikView.htm

Regards,
Brett