topic Re: Calling qvw from another qvw in QlikView

Calling qvw from another qvw

elie_issa — Tue, 10 May 2016 07:24:53 GMT

Dear All,

I have qvw reloader scheduled to be run daily at 8:00 AM on QMC.

All I want to do is to create another qvw file to call the qvw reloader to run another time at 12:00 PM.

what is the best way to do it ?

Thanks.

Re: Calling qvw from another qvw

Colin-Albert — Tue, 10 May 2016 17:07:11 GMT

With QlikView server, you will need a publisher licence to enable more than one schedule (trigger) for a single reload task.

Can you set your original reload task to run every 4 hours - this will then reload at 8am, 12pm, 4pm etc, or more frequently. The reloads should be transparent to your users as the document will update in the background.

Re: Calling qvw from another qvw

elie_issa — Tue, 10 May 2016 17:15:45 GMT

We do not have publisher for now and i was running the schedule every 4 hours but we have some issues and we need to run it only 2 times and i need to run the first reloader automatically from another qvw.

Thanks for your support.

Re: Calling qvw from another qvw

Colin-Albert — Tue, 10 May 2016 20:27:43 GMT

You can chain reload tasks using the "on event of another task" to start the reload after another reload has finished.

Re: Calling qvw from another qvw

santiago_respane — Tue, 10 May 2016 20:50:43 GMT

Hi Elie,

i dont know what you mean by qvw reloader, maybe you can elaborate more in order for us to help you.

You can reaload qvw apps via command line, and qlikview can execute commands so an option is to create a new Qlikview App that executes something like this in the script:

EXECUTE cmd.exe /C "D:\Program Files\QlikView\QV.exe" /r "$(Path to the qlikview app to be reloaded)";

Or a batch that executes the following:

"D:\Program Files\QlikView\QV.exe" /r "Path to the qlikview app to be reloaded"

and you can schedule the execution of this via task scheduler.

Let me know if this helps.

Kind regards,

Re: Calling qvw from another qvw

elie_issa — Thu, 12 May 2016 08:20:40 GMT

Hi Santiago,

I have created a qvw file and put the below script :

EXECUTE cmd.exe /C "C:\Program Files\QlikView\QV.exe" /r "$(E:\WebDeployment\Others\User Logging.qvw)";

When i am reloading the file I am getting in the script execution process the below:

EXECUTE cmd.exe /C "C:\Program Files\QlikView\QV.exe" /r "" done

But The user logging file is not reloading.

Please advise. I need to run the qvw file automatically from the QMC.

N.B : Also when running the reload i am getting the pop up (screen below). how to avoid this pop up automatically without pressing Manually.

Thanks.

Re: Calling qvw from another qvw

santiago_respane — Thu, 12 May 2016 13:39:47 GMT

Hi Elie,

regarding the pop up, you can disable it from the script window itself, there's a tab Settings at the bottom and a check box that allows the app to execute external programs.

And regarding your reloading error i think you should remove the $() from your path the qvw to be reloaded, like this:

EXECUTE cmd.exe /C "C:\Program Files\QlikView\QV.exe" /r "E:\WebDeployment\Others\User Logging.qvw";

Or have the path in a vatiable and use it in the EXECUTE, like this:

SET myVar = "E:\WebDeployment\Others\User Logging.qvw";

EXECUTE cmd.exe /C "C:\Program Files\QlikView\QV.exe" /r "$(myVar)";

Let me know if this helps.

Kind regards,

Re: Calling qvw from another qvw

elie_issa — Thu, 12 May 2016 14:15:55 GMT

I am getting the below when reloading the script after removing the :

EXECUTE cmd.exe /C "C:\Program Files\QlikView\QV.exe" /r "E:\WebDeployment\Others\User Logging.qvw" done

But the User logging.qvw is not reloaded.

Re: Calling qvw from another qvw

santiago_respane — Thu, 12 May 2016 15:55:07 GMT

Hi, i recommend you to verify the paths used, also you can try to run it from a batch file in order to know whats the issue.

You syntax seems fine so from here it is hard solve it.

If you have more info please provide it in order to help.

Kind regards,

Re: Calling qvw from another qvw

santiago_respane — Thu, 12 May 2016 16:52:37 GMT

Hi again,

The app to be realoded is in another machine (E:)?

Maybe there can be an issue with that, try to reload it locally first to verify that, if the app still wont get reloaded we'll have to investigate deeper.

Kind regards,

Re: Calling qvw from another qvw

elie_issa — Fri, 13 May 2016 07:42:19 GMT

I have created a batch file and it's working now.

But what i really need is to run the script inside the qvw and to show that the qvw is reloading in the QMC.

So in fact , what I am asking for is that i want to create a new qvw named "reload of user at 12" and this qvw will call the below shown file "reload of User logging" to be reloaded at 12 PM.

Re: Calling qvw from another qvw

Colin-Albert — Fri, 13 May 2016 14:00:13 GMT

Reloads from a batch file will not populate the status window in the QMC.

The QMC status window is reading the QlikView Distribution Service QDS logs from the ProgramData\qds folder.

Batch file reloads will only populate the document log in the folder where the qvw is located.

To see the status and history in the QMC you need to schedule the reload using the QMC & QDS.