Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I'm reloading QlikView with a scheduled task. I have opened QlikView and I execute the task but the information is not refreshed.
In the task I have put: "C:\Qv.exe" /r /v "C:\Example.qvw"
THANKS!!!!!!
Hi aritzaresti,
Are u sure that your QV.Exe is on "C:\" ?
Normally, it's installed in "C:\Program Files\QlickView\".
Check this first and tell me.
Kindly,
Hi again,
Another point :
You use the switch /v (pass a variable) but you don't pass any value.
Example from Rob Wunderlich:
1. The variable must be predefined in your qvw. Use Settings, Variable Overview to add the variable "MyVar". You do not need to assign it any value.
2. Use the variable in the command line switch
/vMyVar=file2.csv
3. Then you can receive the variable in the script as follows.
LOAD * FROM $(MyVar);
Kindly,
Hello NALLET!
My QV.Exe isn't on "C:\", I've put it to simplify.
And the /v is because I've read something about automatic reload in one post. I dind't know its function 😞
Oki 😉
See below the list of possible switchs (i know that it doesn't answer your problem but ...)
/r | Reload, save, close. |
/rp | Partial-Reload, save, close. |
/l | Reload, leave open. |
/p | Partial-Reload, leave open. |
/v | Pass variable. |
I created a test.qvw.
After, i created a scheduled task with this command line :
"C:\Documents and Settings\All Users\Start Menu\Programs\QlikView\QlikView 10.lnk" /r "C:\Documents and Settings\e0145004\My Documents\QlikView_DEV\QV_APPLI\ZZ_Tests\test.qvw"
This works but, are you sure that you have permission to execute scheduled tasks on your machine. Perhaps must you execute your task with an administrator account?
The problem is if you have QlikView opened. The task works perfectly but the screen is not refreshed.
Sorry, i didn't understood.
the problem is that refresh command is only available with on QlikView Server.
Help, for refresh command says :
"This command is only available with documents opened on QlikView Server and when there is a newer version of the document available on the server. When invoking a refresh, you will get access to the latest data while maintaining your session including selections and layout state."
Hope you'll find another solution, perhaps with a trigger "OnPostReload" for example, and a macro !?
Good luck.
Kindly,
Thaks for all!
Have a happy weekend!