Solved: Re: running macro for document reload - Qlik Community

Report Inappropriate Content · ‎2012-12-19

Hello,

I want to introduce a button for reload. For this , I wrote a macro that executes the operation...'ActiveDocument.Reload'.

But, since it didn't work, I checked the boxes 'Allow macro execution on server' and 'Allow unsafe macro execution on server'.

But, even after this, its not working. Do I have to write an edx for this?

Please suggest some ideas. I use qlikview version 9.00 SR7

Thanks and Regards,

Anju

Report Inappropriate Content · ‎2013-01-24

Hi All,

I tried a number of methods including macro, batch file and EDX .

All of them would throw some issues when server and client were on different machines.

So, finally, we spawned a separate server side task,

and with some C# , created a dashboard with a 'Reload' button (so, it was a one time job).

On click of the button, a request would be sent to the server side task which would invoke

the batch file with report name as parameter.

And, reload was working fine !

(We had to resort to this roundabout way as we are using Qlikview version 9 and we were doubtful whether an upgrade to version 11(in which reload option is present) would not support some drilldown functionality that we had already implemented).

The contents of the batch file :

"C:\Program Files\QlikView\Publisher\Distribution Service\QlikviewDistributionService.exe" -r="C:\QlikViewMount\%1"

Additionally, listing some C# code we used..

1)Initializing :

using AxQlikOCXLib;

using QlikView;

private AxQlikOCX axQlikOCX1;

this.axQlikOCX1 = new AxQlikOCXLib.AxQlikOCX();

2) To fetch the report name :

string[] reportPath = axQlikOCX1.ActiveDocument.Name.Split('\\');

string reportName = reportPath[reportPath.Length - 1];

3) To refresh the report :

axQlikOCX1.ActiveDocument.SetClearState();

Regards,

Anju

View solution in original post

pauljohansson · ‎2012-12-19

Hi,

See similar question:

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

br

Paul

Report Inappropriate Content · ‎2012-12-19

Hi,

I did see that.But , it says that the user must be a part of Qlikview Administrator Group.

I don't know whether this will be feasible for the client.

Thanks and Regards,

Anju.

Report Inappropriate Content · ‎2012-12-19

How do I add a user to the Qlikview Administrator Group or EDX Group?

pauljohansson · ‎2012-12-19

Hi,

you find the Qlikview Administrator Group in the computer management console:

The EDX group needs to be created manually,

br

Paul

Report Inappropriate Content · ‎2012-12-19

Hi,

Thanks ! I checked it..The username I am logging in as is listed in this group..

But when i try to run a .vbs script using command cscript...it tells me that I need to be a part of this group.

Also, I created the group 'QlikView EDX'.But, it is giving me the same error.

Thanks and Regards,

Anju

pauljohansson · ‎2012-12-19

You can confirm in the management console that the user actually is a member of the required group:

Report Inappropriate Content · ‎2012-12-19

Hi,

The screen shot is not clear.....I am using this.....http://localhost:4780/qemc/SystemSetup.htm#....but....there I am not able to find any tab with this option...

Thanks and Regards,

Anju

pauljohansson · ‎2012-12-19

Click on the picture to get it clear

brindlogcool · ‎2012-12-19

Hi,

I think the Activedocument.Reload will work only in Desktop and

It wont work if you are trying to reload from the Accesspoint.

document reload without reload button