topic Re: Trigger OnOpen: Reload - Reload Fails in QlikView

Trigger OnOpen: Reload - Reload Fails

Fri, 26 Sep 2014 07:27:22 GMT

Hi all,

I have developed a .qvw at a client and they insisted on having the document reloaded every time it is opened. So I have triggered the document to reload 'OnOpen'.

However, now that I want to review the document on my local machine I don't have access to the database and logically, the reload fails. When it prompts me to 'Reload old data?' I select 'Yes' and QlikView returns with an error: 'QlikView 11.20 SR5 has stopped working'.

Is there any way that I can delete the OnOpen trigger or edit the script without actually opening the document?

Best regards,

Joost

Re: Trigger OnOpen: Reload - Reload Fails

simonc-cfn — Sat, 31 Jan 2015 23:15:12 GMT

Greetings Joost,

You can perform the following steps to bypass triggers or macros setup to trigger OnOpen of a QVW...

1. Open the QlikView Desktop application.

2. Locate the QVW of interest in the folder where it resides

3. Make sure the Desktop application and folder where the QVW resides are as windows side by side

4. Hold down the Shift button on the keyboard.

5. Click the left mouse button (for right hand mouse users : ) to drag the QVW file into the QlikView Desktop application

6. If follow correctly, holding down the Shift key while opening the QVW will prevent macros and QV triggers from executing.

Hope this helps.

Simon

Re: Trigger OnOpen: Reload - Reload Fails

sujeetsingh — Sat, 31 Jan 2015 23:32:24 GMT

The only thing i will recommend you is that the EDX Event Driven Execution.

This supports the event driven reloads by the server.

Follow this thread it is deeply based on this topic

Using EDX in QlikView 11 - basic example

EDX Trigger - External Event

Re: Trigger OnOpen: Reload - Reload Fails

Mon, 02 Feb 2015 08:43:07 GMT

It worked. Thank you!