topic Re: Execute Macro to Reload documents on Server in QlikView

Execute Macro to Reload documents on Server

pljsoftware — Mon, 26 Jan 2026 18:19:17 GMT

Hi guys,

I must to write a macro that start the reload of an other document e.g. :

Doc A contains a macro that reload the Document B.

sub Reload()
'Macro in Doc A
Dim WshShell
Set WshShell = CreateObject("WScript.Shell")
Set oExec = WshShell.Exec("C:\Program Files\QlikView\Qv.exe /r D:\Test Reload\ExternalReload.qvw")

Set WshShell = nothing
Set oExec = nothing
end sub

My macro run correctly on local client but if I put the documents on server and open they by remote connection the reload do not work.

Somebody know how can I doing this?
Is possible to write a macro that can be execute on server and not on client when I open a document from remote connection?

Thanks in advance

Luca Jonathan Panetta

PLJ Software

Execute Macro to Reload documents on Server

Mon, 11 Apr 2011 16:11:44 GMT

Did you try realoding this document using publisher?

Re: Execute Macro to Reload documents on Server

pljsoftware — Mon, 11 Apr 2011 16:16:54 GMT

No! I use the command line to make the reload.

Luca Jonathan Panetta

http://www.pljsoftware.com

Execute Macro to Reload documents on Server

Mon, 11 Apr 2011 16:39:51 GMT

1. Are these two documents are loading independently on the server?

If YES, I dont see any reason why it wont run using macros.

Also you could try with Publisher.

Re: Execute Macro to Reload documents on Server

pljsoftware — Mon, 11 Apr 2011 17:51:17 GMT

No, they are dependently.

Document A is used to verified data, when data are checked the user click a button and I want to enabled the reload of document B.

------------------------------------

Luca Jonathan Panetta

PLJ Software

Execute Macro to Reload documents on Server

Miguel_Angel_Baeyens — Tue, 12 Apr 2011 05:04:04 GMT

Hello Luca,

I may be missing something here, are you running a QlikView Server? Meaning are you opening the document on server using clients (IE Plugin, AJAX)? If that's the case, then take into account that not all macros work nor can be triggered by buttons/actions, in first place, in second you will need to set up the server so it allows the execution of non-safe macros and system-access macros, and third, you have to ahve installed the Desktop application in your server, since qv.exe is the Desktop executable.

Hope that helps.

Execute Macro to Reload documents on Server

pljsoftware — Fri, 20 May 2011 16:47:04 GMT

Hello guys,

I have solved it by an table on my DB where I update a value that say me if I must to reload my data.

Thanks!

------------------------------------

Luca Jonathan Panetta

PLJ Software

Re: Execute Macro to Reload documents on Server

Mon, 14 Jan 2013 05:55:03 GMT

Hi Luca,

Could you please elaborate how you did that?

Is it like this?

When a user clicks a button , some setting is inserted into the db, and then the server detects this , and runs a reload?

But, what is to be done to achieve this?

Thanks and Regards,

Anju

Re: Execute Macro to Reload documents on Server

pljsoftware — Tue, 15 Jan 2013 12:19:51 GMT

Hi Anju,

I have loose my example, but I explain you how I had make it.

You must to create a table on you DB where you insert or update a value in a specific field, e.g. UpdateFieldFlag.

To make this you must to use the macro to write this new value into your DB table.

After in your Qlikview script you test your UpdateFiledFlag and make what you want.

To insert data in DB look this http://community.qlik.com/message/135858#135858

I hope this help you.

Regards

Luca Jonathan Panetta

PLJ Software

Re: Execute Macro to Reload documents on Server

Tue, 15 Jan 2013 17:52:49 GMT

Hi Luca,

How are you reloading the dashboard based on the database value?

Is it happening manually or through EDX triggers? we have a similar kind of situation wherein i need to reload the dashboard whenever the user opens the web page(where we load the dashboard in an IFrame).

We tried using EDX Triggers but are facing issues in implementing them.

Ref: http://community.qlik.com/message/300170#300170

Thanks

Sai Krishna

Re: Execute Macro to Reload documents on Server

Thu, 24 Jan 2013 07:27:01 GMT

Hi All,

This issue is fixed!.

Please see this thread!

http://community.qlik.com/message/293671#293671

Regards,

Anju