topic Re: Reload after external program ends in QlikView

Reload after external program ends

Sat, 21 Dec 2013 13:24:26 GMT

Hi,

I have a macro which is calling an external program (not a batch),

where the user generates a report which is loaded to QV.

I would like to trigger a reload only after the external program is terminated.

Is there a way to know when?

Thanks!

Re: Reload after external program ends

Gysbert_Wassenaar — Sat, 21 Dec 2013 15:12:07 GMT

No idea. The external program should do something that indicates it has finished and can be checked. Your macro could include this check in a loop with a sleep period and only exit the loop when the check indicates the external program has finished. Then have the macro run the reload.

Re: Reload after external program ends

Sun, 22 Dec 2013 09:29:31 GMT

Hi,

I would rather add a "Refresh" button at the moment.

Maybe there is an option to capture the first user interaction with QlikView after running the macro, but I don't know how to do it.

Re: Reload after external program ends

qlikpahadi07 — Mon, 23 Dec 2013 05:47:27 GMT

If I understood correctly then may be it's because you work when your QVW is open and it will not get save so, you need to refresh your QVW.

Try to create a Batch file to reload that QVW which will run the Macro and save it.

Re: Reload after external program ends

Tue, 24 Dec 2013 17:40:01 GMT

Hi,

Thanks for your input.

The scenario is different: the user triggers an external interactive interface with report generation.

But there is no way to know when he is back in QlikView in order to reload the data generated by the external report.