Calling qvw from another qvw

[elie_issa]

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.

[Colin-Albert]

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.

[elie_issa]

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.

[Colin-Albert]

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

[santiago_respane]

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,

[elie_issa]

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.

[santiago_respane]

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,

[elie_issa]

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.

[santiago_respane]

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,

[santiago_respane]

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,