Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
aniruddhyadutta
Contributor

Reloading .qvw files based on action button in another document

Hi All,

I am trying to make work an app where a button click will help me to reload all the other .qvw based on  entries in an  excel list.

But some how I am getting 'failed to open document" error.Can anyone plz help me on this? I am attaching the excel I am using which has the list of qvw on my local.You can just update the file name and doc name while testing in your local in the excel entries.

Might be I am making some mistake while creating the entries in the excel?

6 Replies
OmarBenSalem
Esteemed Contributor

Re: Reloading .qvw files based on action button in another document

Can You try this in the script; change somethings in you other qvw files and see what happens?

If they trully reload?

QVDocuments:

LOAD FromDirectory,

     QVDoc

FROM

(ooxml, embedded labels, table is Sheet1);

EXECUTE cmd.exe

"C:\Program Files\QlikView\qv.exe" /R  "\\FromDirectory\QVDoc";

let LastReload = now();

aniruddhyadutta
Contributor

Re: Reloading .qvw files  based on action  button in another document

Capture.PNG

Hi Omar,

Thanks for your reply.I am getting the above error. can it be a reason for format in which I am executing?

OmarBenSalem
Esteemed Contributor

Re: Reloading .qvw files  based on action  button in another document

Make sure you are allowing binary reloads i, Settings, Document Properties, Opening tab, uncheck "Prohibit Binary Load".

Make sure that the check "Admin Overrides Security" is also checked in the Document Properties, Security tab.

Hope that helps

aniruddhyadutta
Contributor

Re: Reloading .qvw files  based on action  button in another document

I have checked all the settings and they are as per you recommended.

I want to understand how you are getting "\\FromDirectory\QVDoc"; this information from the resident table?

is it like since there is only one table its doing a binary load? in that case how its going to the specific column in the excel through the batch command i.e "\\FromDirectory\QVDoc"; ?

MVP
MVP

Re: Reloading .qvw files based on action button in another document

You are probably missing a back slash in path, try like:

Set Doc = App.OpenDoc(FromDirectoryLoc & "\" & myDocName  )

aniruddhyadutta
Contributor

Re: Reloading .qvw files  based on action  button in another document

worked like a charm!!! 

Thanks a ton Tresesco..