Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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..