Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

document reload without reload button

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

42 Replies
selcukcadir
Creator II
Creator II

hi,

qlikview server 11 installed. qlikview services is running.

C:\Program Files\QlikView\Publisher\


This folder does not exist.

Not applicable
Author

Hi,

I am not sure what the problem.

But you need not have publisher.

You can also reload using this command:

qv.exe /r document.qvw


This only requires a client installation.


Regards,

Anju

selcukcadir
Creator II
Creator II

first .qvw reload ok.

thanks.

"C:\Program Files\QlikView\Publisher\Distribution Service\QlikviewDistributionService.exe" -r="C:\test.qvw"

How to reload other documents? on successfully >> other qvw

task1.png

Not applicable
Author

You have two options:

1)in each report , write a macro with the above command,

and call it with a button click.

or,

2) write the command in a batch file with %1 instead of document name

and, call this batch file with button click while passing document name as parameter.

-Anju

selcukcadir
Creator II
Creator II

Hi Anju, Thank you. for your help...

Can you share a sample file? I do not understand fully.

Not applicable
Author

which version of qlikview are you using?

Not applicable
Author

you can try this:

put this command in a .bat file

"C:\Program Files\QlikView\qv.exe" /r "<document path>\%1"

in each of your qvw documents:

create a button and add an action

external -> open url -> paste the path of the .bat file.

On button click, reload should happen.

-Anju

Not applicable
Author

selcukcadir
Creator II
Creator II

my document;

create a button and add an action

external -> run macro >

Sub External2

Set WSHShell = CreateObject("Wscript.Shell")

     WSHShell.Run("c:\test2.bat") 

           

     ActiveDocument.GetApplication.WaitForIdle 3000

     ActiveDocument.Variables("vReloadStatus").SetContent "1", true

    

End Sub    

Push bottun error ;

error_access_point.png

Your method ;

external -> open url -> test2.bat  ?


http:\\mydomainadress.com\qlikview 


how will ?

Not applicable
Author

yup,,, can u try these

c:\test2.bat

"c:\test2.bat",

c:\\test2.bat

.and so on..