topic Re: Macros not working after task reload in QlikView

Macros not working after task reload

Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

I am having some problems getting macros working on our Qlikview server. The macros work fine if I reload the data locally in a Qlikview client and then publish the file, however if I add a task that first reloads the data and then publishes the file then the macros do not work anymore (they are not executed). It is not only that the macros does not work when accessing the file trough the IEPlugin, they do not work even if I open the qvw file in a local client. Does anybody know the reason for this and who to get around it?

Any help appreciated.

Re: Macros not working after task reload

magavi_framsteg — Mon, 28 May 2012 13:26:36 GMT

Hi Robbjohn.

Do you mean you have macros who execute OnPostReload?

If so:

- Macros are *only* executed on manual reloads via QV Desktop (QV.exe)

- Macros are *not* executed when reloading via Publisher (QVB.exe)

What are you trying to do in your macro code?

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.

Re: Macros not working after task reload

Mon, 28 May 2012 13:33:26 GMT

Hi Magnus.

No, the marcos are not triggered by the OnpostReload event. They are normal macros that are triggered by a button. The macros first create a text file and then execute a command.

As I previously said, the macros work fine if I just publish the document, however if I add a task to reload the document then after the reload the macros do not work anymore (they are not executed)....

Re: Macros not working after task reload

magavi_framsteg — Mon, 28 May 2012 13:40:33 GMT

Hi again.

Do you have "Document properties > Security > Macro override security" checked?

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.

Re: Macros not working after task reload

Miguel_Angel_Baeyens — Mon, 28 May 2012 13:43:19 GMT

Hi,

Do you mean that after publishing the document, you click on the buttons and that no longer triggers the macros? Does it work if you use the Launch action instead? Are you allowing unsafe macro execution on server?

Did you open the distributed documents with Desktop to check whether or not the macro still works?

Miguel

Re: Macros not working after task reload

Mon, 28 May 2012 13:52:07 GMT

Hi Miguel.

Let be more exact.

Imagine two scenarios.

First scenario: I create a task that publishes the document. Macros work fine.

Second scenario: I create a task that first reloads the data and then publishes the document. Macros do not work anymore. Does not matter if i open the document in a desktop client or trough the IEplugin, macros are simply not executed, i.e. something happens to the file when it is reloaded. However if i reload the file in a desktop client macros continue to work.

Macro override security is checked.

I am allowing unsafe macros.

Re: Macros not working after task reload

Miguel_Angel_Baeyens — Mon, 28 May 2012 14:14:19 GMT

Hi,

The only difference between Desktop reloads and Publisher (not Server) reloads is that QlikView Publisher removes the script to the published documents. It's not a bug, as far as I know. So it would make sense if you were loading your macros in the script, as long as it is removed by Publisher (open any reloaded file and you will see a comment line noting that there is no script).

Which version of QlikView are you running? Does the module editor have macros even if they are not executed when you open the reloaded document in Desktop?

Hope that makes sense.

Miguel

Re: Macros not working after task reload

Tue, 29 May 2012 07:10:53 GMT

Ok, so i found the problem (silly problem, silly me), but I do not know why it occurs.

It seems like when a .qvw is reloaded trough a task, triggers are removed (I said earlier that macros are executed trough buttons, when they really are executed trough triggers when a certain selection is made. Did not think it mattered). So any body knows why this happen, and how to avoid it?

Re: Macros not working after task reload

magavi_framsteg — Tue, 29 May 2012 07:19:00 GMT

Hi again robbjohn.

Triggers should never be automatically removed depending on how the reload was made - so be it manual or by publisher task.

However ,if you have a field event trigger OnChange, the trigger will be removed if the underlying field gets removed from your data model. Even if the field comes back, the trigger will still be gone.

This behavior was reported as a bug on QV v9 by me a few years ago, but it still exists as of QV v11 SR1.

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.

Re: Macros not working after task reload

Tue, 29 May 2012 07:25:02 GMT

Hi Magnus.

Hm, I am not using the OnChange but the OnSelection event... But if I understand you correctly this basically should not happen, yet it does (however as I mentioned earlier if the document is reloaded in a desktop client it does not happen)... A new bug? We are using QV11....

Re: Macros not working after task reload

magavi_framsteg — Tue, 29 May 2012 08:36:41 GMT

Hi again.

Yes it might be a bug, OnChange and OnSelection should work all the same, technically.

And they should not work differently depending on how you reload.

Create a "dummy" document and send to QV Support and explain the behavior to them.

They can usually reproduce your problem, and it gets filed as a bug.

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.

Re: Macros not working after task reload

Anonymous — Thu, 01 Jun 2017 01:41:08 GMT

Hi Magnus,

Do you any work around for the problem you stated in this comment.

I am facing same problem :

- Macros are *only* executed on manual reloads via QV Desktop (QV.exe)

- Macros are *not* executed when reloading via Publisher (QVB.exe)

I am exporting a chart data after QV reload.

Thank,

Sanjay