topic Re: Reload a qvw from another qvw -via user button in QlikView

Reload a qvw from another qvw -via user button

leenlart — Sat, 16 Nov 2024 04:55:31 GMT

Hello,

I have a couple qvw's that can't be programmed to be updated at a certain time. The Cost Management team has to run a script that will update the data that is then uploaded into the qvw. I'm looking for a solution to avoid having to be ready and available to click to run the update task for the qvw in the QMC.

I'm considering adding a button to reload and save in the qvw for the cost management team to use when they are ready to update.

However, I've run into a problem : the qvw is a binary load from another qvw.

I've been fiddling around with the following macro to put on my button, so that the user can update the first qvw (that they never see) and then update the final qvw.

Here's what I've got so far, but I think there is a problem in my Set Doc but I'm not sure what.

And I'm then worried that ActiveDocument is a bit too ambiguous.

Any ideas? Is this doable?

Sub Reload

Set Doc = App.OpenDoc( [document path and name here] )

Doc.Reload
Doc.Save
Doc.Close

ActiveDocument.Reload
ActiveDocument.Save

End Sub

Thanks!

Re: Reload a qvw from another qvw -via user button

Somasundaram — Thu, 20 Dec 2018 10:01:12 GMT

you may create .bat file and refresh from from command prompt.

once run the .bat file , QVW file will get refresh.

"c:\Program Files\QlikView\QV.exe" /r \\shared location\file.qvw

Re: Reload a qvw from another qvw -via user button

leenlart — Thu, 20 Dec 2018 10:03:46 GMT

That would be great, but I'm looking for something two users to run. Two QV users that aren't necessarily command prompt savy.

Re: Reload a qvw from another qvw -via user button

leenlart — Fri, 18 Jan 2019 14:21:48 GMT

So what we ended up doing was creating a button on our intranet, where the users could run the batch that reloads the two qvws.

I did however have to fiddle around a bit before I got the batch to run. In the end I got this to work :

CALL "C:\Program Files\QlikView\Distribution Service\QVDistributionService.exe" -R="D:\QlikView_documents\APPLI_1.qvw"
CALL "C:\Program Files\QlikView\Distribution Service\QVDistributionService.exe" -R="D:\QlikView_documents\APPLI_2.qvw"
Exit

so -R= instead of R/